Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “ileitis” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ileitis73806(None) 
ileitides1045622ileitides
illites72415012illites
illitic939252illitic
iritis63113732i_ritis
uveitis1043682uveitis
adenitis947453adenitis
albites9313213albites
albitic1139133albitic
alerts64418223alert_s
alibis8311073al_ibis
bleats85518623bleat_s
blets75324943ble_t_s
blinis85313683bl_inis
blites84721213bl_ites
ceilis85413743_ceilis
cleats84919313cleat_s
clefts114610163cleft_s
clematis1248653clematis
clevis1158963cle_vis
clitic103315053cl_itic
clitics11279973cl_itics
colitis92617353colitis
colpitis1247503colpitis
coxitis16238463coxitis
deities82621923_deities
deixis1437243_deixis
elects83315003elect_s
elegits8149343elegit_s
elemis8312383ele_mis
elites66027123el_ites
elitism939763el_itism
elitist7414913el_itist
filets94718953file_t_s
fleets96915063fleet_s
flites95122443fl_ites
flits85625223fl_it_s
gelatis83313513gelatis
gleets75315053gleet_s
glottis837173glottis
ideates8313733ideates
identic1038043identic
ignites81310583ignites
ileus54616893ile__us
ileuses738673ileuses
ilexes134510253ile_xes
iliads7448673il_iads
illicit949833illicit
illite63414923illit_e
ilmenites1146103ilmenites
incites93218483incites
indites83618983indites
inertia7410203inertia
inertias8410383inertias
inerts64517023inert_s
inlets63915573inle_t_s
intis55121643i__ntis
invites103915813invites
iolites73819483iolites
iritic83213823i_ritic
islets64513083isle_t_s
kleptos1344363kleptos
laities7320343_laities
lectin82515013_lectin
lectins92515003_lectins
leets54927123_leet_s
lefties10312073_lefties
leftish13197253_leftish
leftism12226093_leftism
leftist10279353_leftist
lefts86517813_left_s
legits71313003_legit_s
leis45739603_le__is
lenis56326863_le_nis
lenites7818443_lenites
lenities8315943_lenities
lentic83515743_lentic
lentil64315393_lentil
lentils73912973_lentils
lentisk1136063_lentisk
lentos65317403_lentos
leptin82512333_leptin
leptins92412693_leptins
lets47147943_le_t_s
levis85818553_le_vis
levities11310713_levities
lewis85315843_le_wis
lexis125916033_le_xis
limites92915453limites
limits82514143limit_s
litas54923773_l_itas
lits46252503_l_it_s
metis75025903_me_tis
militia949733mil_itia
militias1048633mil_itias
mitis75425993__mitis
myelitis1345113myelitis
oleates7417833oleates
oleines7313393oleines
oleins6313523olei_ns
osteitis847023osteitis
otitis63612343_otitis
pelites93821993pelites
pelitic111814653pelitic
phlebitis1643313phlebitis
plaits83816473plait_s
pleats85218593pleat_s
pleiads1045223pleiads
plenties10314693plenties
pyelitis1346583pyelitis
scleritis1146433scleritis
silents73514493silent_s
sleets64318873sleet_s
sleighs11245673sleighs
sleuths1034743sleuths
slits56128853sl_it_s
testis64916713_testis
thelitis1147513thelitis
tillites8312833tillites
titis56023813__titis
ulexites1534943ulexites
uveitic1244683uveitic
velites103417303velites
vulvitis1442923vulvitis
wapitis1236473wapitis
yetis85418393_ye_tis
zitis145815583__zitis

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.423422437.4
2DLD Change Limit1340271277.11018850.5
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.57923577.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.