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 “tortile” 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.

350 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
tortile731319(None) 
fertile10311732fertile
hostile10312552hostile
mortice11711492mortice
mortise9713532mortise
motile83818342mo_tile
sortie63621992sorti_e
tactile9310612tactile
tartily103511572tartily
textile1437222textile
toile54626492to__ile
tontine72316142tontine
tootle62613812toot_le
torte55431702tort__e
tortilla845892tortilla
tortoise847092tortoise
torture738592torture
turtle63213572turt_le
abortive1346883abortive
airtime948063airtime
amortise10428513amortise
amortize1987743amortize
aortae65115473aort_ae
aortal65217513aortal_
aortic8316613aorti_c
article9310923_article
artily92814713_artily
bastile9313913bastile
bootie85421163booti_e
boride9415903bor_ide
bornite9311183bornite
bottle84916073bo_ttle
centile94217183centile
chortle124210443chort_le
compile13312443compile
cootie84223093cooti_e
coracle112011723coracle
corbie103618203corbi_e
cordite10315263cordite
cornice11612933cornice
cornicle1258783cornicle
cornily12410853cornily
corrie83621223corri_e
cortege1098953cortege
cortices12615013cortices
cortin82423153corti_n
cortina91915973cortina
cortins92421333cortins
corvine122113643corvine
costive12312843costive
dartle73714833dart_le
dirtily1138583dirtily
docile94213123do_cile
dormice1237133dormice
dormie9312623dormi_e
dottily1147283dottily
dottle74212503do_ttle
ductile1048483ductile
erotize16311663erotize
etoile6312263eto__ile
extortive1945143extortive
fictile1238023fictile
footie94718143footi_e
footle93914383foot_le
forcible1545143forcible
foretime1348213foretime
forgive1436193forgive
forte86131463fort__e
forties104323863forties
fortify1636523fortify
fortis95418613forti_s
fortune1068303fortune
furtive1337173furtive
futile93914953_futile
gentile83515293gentile
gorily10612503gor_ily
goutily1137933goutily
hogtie102711773hogti_e
hornily1338283hornily
horrible13135233horrible
horsily1338843horsily
hostiles11312213hostiles
hottie92514383hotti_e
hurtle93512943hurt_le
inutile739883inutile
joltily1746323joltily
jostle13319863jost_le
kirtle10309473kirt_le
loftily1336353loftily
mobile103613543mo_bile
moraine9314573moraine
morale85220553mor_ale
morelle91210803morelle
mortal84616853mortal_
mortals93914003mortals
morticed1377163morticed
mortices12711563mortices
mortify1536223mortify
mortised1178743mortised
mortiser1078473mortiser
mortises10713613mortises
motiles93317433mo_tiles
motive113112143mo_tive
mottle84116053mo_ttle
myrtle1135733myrt_le
nargile847653nargile
nitrile73011373nitrile
noctule936083noctule
nontitle846943nontitle
norite63221133nor_ite
notice8313443no_tice
oorie53026363oor_i_e
optime1079353_optime
oracle84313293_oracle
oreide7311673_oreide
oriel54920423_or_iel
oriole6814293_oriole
orle45630463_or__le
oroide7311703_oroide
orpine83914483_orpine
orrice81410163_orrice
ostiole739013_ostiole
outlie62419533_outlie
outwile10310263_outwile
pantile93918483pantile
partible1238063partible
particle1239533particle
partite9317133partite
poetise9314043poetise
poetize18310773poetize
pontil8315463pontil_
pontils9312213pontils
pontine92419053pontine
porcine11312843porcine
portable12313203portable
portage103013643portage
portal84218463portal_
portaled11239203portaled
portals94015563portals
porthole1349523porthole
portico11310143portico
portiere1038773portiere
porting103021783porting
portion9615493portion
portlier1038373portlier
portly114713403port_ly
portside1138163portside
postie84123963posti_e
pottle84416103po_ttle
poutine93316823poutine
profile123211153profile
protyle12229453protyle
quartile1747043quartile
reptile93914083reptile
retile65929673_retile
rile45650533__r_ile
rootle63214453root_le
routine72615903routine
rutile65217683_rutile
sectile9311973sectile
servile10310643servile
sextile1438573sextile
shortie10411343shorti_e
softie93312483softi_e
sootily101810523sootily
sordine82515233sordine
sorptive1346473sorptive
sorrily1039833sorrily
sortable10312483sortable
sortied83314103sortied
sorties74126403sorties
sortilege1043033sortilege
sorting83221813sorting
sportily1337733sportily
sportive1348333sportive
startle72511123start_le
sterile7316603ster_ile
stile54931573__stile
storable10310733storable
stormily1345243stormily
strobile1047033strobile
subtile91912623subtile
surtitle845283surtitle
tardily11269583tardily
tardive1136893tardive
tartare73012683tartare
tartier74123263tartier
tarting84222653tarting
tartish101512633tartish
tartlet72218483tart_let
tartly96014023tart_ly
tartufe1064673tartufe
tastily103311643tastily
tattie64817513tatti_e
tattily10409993tattily
tattle64115653t_attle
teatime9310083teatime
tectite9310583tectite
tektite1136883tektite
tensile72612733tensile
tentie62521183tenti_e
tergite8311003tergite
termite9313893termite
termtime1244773termtime
terrible1046643terrible
terrine72517573terrine
tertial7313863tertial
tertials8510073tertials
tertian7511193tertian
testicle1037443testicle
testily102910803testily
textiles1536833textiles
thorite10313443thor_ite
thornily1444163thornily
thrice114311573thr_ice
thrill94910593thr_ill
thrive125313223thr_ive
throttle1164083throttle
tile45451443___tile
title54721073t_it_le
tittie63213153titti_e
tittle63613323t_ittle
toddle85811033to_ddle
toelike11149823toelike
toggle83810873to_ggle
toil46536283to__il_
toiled74420323to__iled
toiler63918283to__iler
toiles63923513to__iles
toilet66228093to__ilet
toils54527493to__ils
toiting83217093toiting
tole46052903to___le
toluide835263toluide
toluole736113toluole
tomtit8413853tomti_t
tomtits937243tomtits
tonsil6311873tonsil_
tonsils7310183tonsils
tontines82114733tontines
toonie63617993tooni_e
toothily1445523toothily
tooting83019423tooting
tootled83511043toot_led
tootler73511123toot_ler
tootles72915603toot_les
tootsie737133tootsie
topline92313183topline
topple104411323to_pple
topside1037733topside
tore47359323tor___e
tori47542153tor_i__
toric76529313tor_i_c
torics85118353tor_ics
tories65435883tor_ies
torii55521593tor_i_i
tornillo854623tornillo
toroid7416013toroi_d
toroids8310643toroids
torose64317693tor_ose
torpid9310913torpi_d
torpidly1483653torpidly
torpids1037373torpids
torque15237673tor_que
torrid7311853torri_d
torrider936173torrider
torridly1284473torridly
torrify1335013torrify
torsade837593torsade
torse55833333tor__se
torsi57423363torsi__
torsion7310803torsion
tort46967463tort___
torta55925353tort__a
tortas64918253tort_as
torten65314353tort_en
tortes64826053tort_es
tortillas945183tortillas
tortious839023tortious
tortoises947183tortoises
tortoni738033tortoni
tortrix1444193tortrix
tortrixes1644153tortrixes
torts56138123tort__s
tortured935843tortured
torturer835493torturer
tortures838913tortures
torula6610393tor_ula
torulae758553torulae
totable92313363totable
total55321823to_tal_
totaled839693to_taled
totals63115163to_tals
tote46643673to_t__e
toting74123793to_ting
totting82816843totting
tousle64514653to_usle
touting84118453touting
touzle15429003to_uzle
towable121910113towable
towie85821873to_wi_e
towline102911543towline
townie93312303towni_e
toxine133114123to_xine
toylike14157243toylike
tractile10311073tractile
trail55126773t_rail_
trailed83415673t_railed
trailer73015393t_railer
trails64622513t_rails
treble8311663t_reble
tribe74420273t_r_ibe
trice75127493t_r_ice
trifle94012883t_rifle
trike95320163t_r_ike
trill55122933t_r_ill
trine54734603t_r_ine
tripe75425383t_r_ipe
triple84215923t_riple
trite54730033t_r_ite
tropine93116653tropine
trotline8310023trotline
trotyl9236673trotyl_
trotyls10236033trotyls
trouble957713trouble
tuftily1335573tuftily
turbine9310303turbine
turdine8310283turdine
turgite837973turgite
turnstile943173turnstile
turtled8309683turt_led
turtler72610323turt_ler
turtles72914343turt_les
twattle1064273twattle
utile54718933__utile
verbile1249863verbile
virile9313433vir_ile
voile84719723vo__ile
volatile1146433volatile
vortices1369123vortices
votive12348933vo_tive
wartime1237743wartime
whortle13335943whort_le
wordily1437853wordily
wormil1138043wormil_
wormils1236733wormils
worthily1745253worthily
zoril143916693zor_il_
zorille1636673zorille
zorils153810883zor_ils

Search took 9 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.406440125.6
2DLD Change Limit1340273507.62617575.0
3Display Results3503500.1232845.5
 (SQL Overall)1786913508.15521911.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.