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

205 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
cristae931061(None) 
aristae7312531aristae
crista8311801crista_
cristate10310601cristate
arista6415292arista_
aristas7413522aristas
aristate8312132aristate
bristle91910102bristle
christie1347782christie
costae85319682c_ostae
crestal9312132crestal
crispate1246912crispate
crissa837622crissa_
crissal937412crissal
cristated1247422cristated
crustal939022crustal
crystal1237432crystal
gristle8169222gristle
pristane10310342pristane
tristate8311032tristate
triste63818642trist_e
ariette7312373ariette
arise56436433aris__e
aristo6414033arist_o
aristos7312373aristos
artiste73813693artist_e
barista9310813barista_
baristas1039723baristas
bhistie1236773bhistie
bistate9313823_bistate
bistre83815023_bistre
bristled11187343bristled
bristles101510433bristles
bristly12178063bristly
bristol937043bristol
brittle9168603brittle
capstan1137903capstan
carinae94318583cari_nae
carinate103320243carinate
caritas93316953cari_tas
casita82913703casita_
casitas93312043casitas
caste75932363c_ast_e
castle84918963c_astle
cerise84822043ceris__e
cerite84724873ceri_t_e
cesta75419483c_esta_
cestas85018543c_estas
chaetae1238603chaetae
chaste114617393chast_e
chital114313883chi_tal
chrisma1456823chrisma_
chrismal1575173chrismal
christen13106703christen
christies1449263christies
christy1536623christ_y
cirrate92413493cirrate
cist67244963c_ist__
cisted95217523c_isted
cists76624533c_ist_s
cistus84611343c_istus
cite65640343c_i_t_e
climate11312833climate
cnidae978143cni_dae
coastal9411043coastal
coistrel1046743coistrel
coital84117053coi_tal
costa75523733c_osta_
costal85419513c_ostal
costar85518613c_ostar
costate94019273c_ostate
cottae84615703c_ottae
crate76537403cr_at_e
create85126383creat_e
cremate113816183cremate
crenate93317113crenate
crest74632693crest__
crested103416533crested
crests85218703crest_s
cribbage1542973cribbage
crime94822693cri__me
crimine112413473crimine
crimple13408693crimple
cringe93515483cri_nge
cringle103010353cringle
crinite9513633crinite
crinkle13359413crinkle
cripe95521143cri__pe
cripple13378583cripple
cris66233433cris___
crises84529433cris_es
crisic103611843cris_ic
crisis83716343cris_is
crisp95014623cris__p
crispated1445023crispated
crisped124010103crisped
crispen11348203crispen
crisper113511053crisper
crispier12297253crispier
crisply14426523crisply
crisps104411513cris_ps
crispy13478563cris_py
crissum1144843crissum
crit65743713cri_t__
critic103616813cri_tic
crits75527573cri_t_s
critter94113033critter
crittur9315133crittur
crosse85216303cros_se
crosstie1046933crosstie
croustade1243943croustade
croute84617273crout_e
cruise84314043cruis__e
crusade1036053crusade
cruse75726103crus__e
crust75827663crust__
crustacea1342663crustacea
crusted103712753crusted
crustier10259533crustier
crustose1045503crustose
crusts84916543crust_s
crusty114911343crust_y
cryostat1395743cryostat
cryptal1445683cryptal
crystals1347173crystals
cuesta838513cuesta_
cuestas957933cuestas
cuisine9310423cuisine
cuisse8318333cuis_se
cuittle946403cuittle
curiae84518373curi__ae
curite85222943curi_t_e
distal73615773_distal
driftage1342933driftage
epistle957893epistle
eristic9814093eristic
frigate11311063frigate
frisbee12298513frisbee
frise85322453fris__e
frisee94217993fris_ee
frisette1195483frisette
frusta937453frusta_
grisette994653grisette
grist65529873grist__
grister83915413grister
gristles9189203gristles
gristly11187333gristly
grists74716483grist_s
istle52214713__istle
listee64223063_listee
misate81222693_misate
mistake131312623_mistake
orisha936773orisha_
orishas1036473orishas
piste75824603_pist_e
primate111516283primate
prise74632613pris__e
prisere9310943prisere
pristanes11410433pristanes
pristine10313503pristine
private121513263private
prostate10314533prostate
prostie91617743prostie
restage83316193_restage
restate73824883_restate
riata54618023_riata_
riatas63915093_riatas
rictal83113183_rictal
rise45945233_ris__e
risque15227453_risque
ristra6310713_ristra
ristras7311563_ristras
rite45849453_ri_t_e
rustle63615413_rustle
sacristan1143573sacristan
testae64216253_testae
thistle10107803thistle
trestle72611363trestle
triptan947543triptan
triptane1047563triptane
triseme936543triseme
trishaw1344753trishaw
trisome9310223trisome
trite54730033tri_t_e
trustee73514443trustee
tryste9399583tryst_e
turista737443turista_
turistas846693turistas
urinate7315363urinate
ursae55214453ur_s_ae
vista85416603_vista_
vistaed1138023_vistaed
vistas94513273_vistas
vitae84217633_vi_tae
vittae93911003_vittae
whistle13107533whistle
wrastle10368993wrastle
wrestle10298843wrestle
wrist84827563wrist__
wristier1136863wristier
wristlet1138643wristlet
wrists95415643wrist_s
wristy12509703wrist_y
write85522833wri_t_e
writhe125310703wri_the

Search took 7 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 Limit1340272056.22021547.7
3Display Results2052050.0932204.3
 (SQL Overall)1786912056.71926594.9
 
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.