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

373 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
durians83957(None) 
durian7312001durian_
durions839961durions
burans85019302bur_ans
burials93612082burials
burins84221892buri_ns
currans9310612currans
drains73719402d_rains
dulias71212742dulia_s
duras65727722dur_a_s
durbars1077972durbars
during84419402duri_ng
durion7510962durion_
durns64819862dur__ns
durras74713372durra_s
furans94515952fur_ans
kurgans12145652kurgans
lurdans837072lurdans
parians93519732parians
purins83722652puri_ns
puritans1037632puritans
saurians837762saurians
turbans939562turbans
turions7311572turions
urials64415192_urials
aerials74017553aerials
agrias74315393agria_s
anurans73810553anur_ans
anurias7312253anuria_s
aquarians1845873aquarians
arias55438023_aria_s
auras55932553aur_a_s
auris55331533auri__s
aurists74615783aurists
auxins13129813auxi_ns
avians93711563_avians
banians9312033banians
biriani945643biriani
birianis1056343birianis
brains85125473_brains
brans75437433_br_ans
briars84814823_briars
brins75533973_bri_ns
bruins86014953brui_ns
bunions92210473bunions
buran75225303bur_an_
buras74736293bur_a_s
burdens1039713burdens
bureaus979293bureaus
burial84117623buria_l
buriers94017193buriers
buries84633273buri_es
burin75626063buri_n_
burkas124513803burka_s
burlaps1156253burlaps
burns74926773bur__ns
burqas174410903burqa_s
bursars94510893bursars
bursas85318273bursa_s
burtons9310853burtons
carinas93622403carinas
cerias83321983ceria_s
corbans11313173corbans
courlans10117613courlans
crucians1245293crucians
cuirass934973cuirass
cumins103314933cumi_ns
curia74523773curia__
curiae84518373curia_e
curial84019153curia_l
curies84934023curi_es
curing94824783curi_ng
curios83218333curi_os
curious93813563curious
curites93919863curites
curiums1138503curiums
curns74924273cur__ns
curran8312023curran_
currant9314173currant
currants1037933currants
curtains10259703curtains
curtals93111623curtals
cutins83919983cuti_ns
cyprians1544213cyprians
damans94715983d_amans
damiana1046563damiana
damianas1155573damianas
dans56748153d___ans
darbars10510093darbars
darics94314113dari_cs
daring84928683dari_ng
darings93713653darings
darkens12409873darkens
darns66927893dar__ns
darshans1286543darshans
deans66131393d__eans
decrials1137133decrials
decurions1246023decurions
dedans85915073d_edans
deewans11306903deewans
defiant11311923defiant
deigns8389983d_eigns
demeans1039713demeans
denials84114133denials
deraigns1034883deraigns
derails84216393derails
derats74625063der_ats
derays105514253der_ays
derides93420853derides
derives114017813derives
dermas94116813derma_s
designs9328313designs
desmans1039003desmans
detains83716093detains
detrains9411763detrains
deviant11311313deviant
deviants1236733deviants
dewans105215143d_ewans
dhurnas1153443dhurna_s
dials64925343d__ials
dins56652043d__i_ns
dioxans1555313dioxans
dirams94413703dir_ams
dirhams13376313dirhams
diurnals943803diurnals
diurons838823diur_ons
divans104612393d_ivans
diwans105110373d_iwans
djinns1443133d_jinns
djins1368453d_ji_ns
dolmans10479683dolmans
domains10510873domains
dories75232363dori_es
dormant102814373dormant
dormins10311273dormins
dorsals84110843dorsals
dourahs11487253dour_ahs
douras75016723dour_a_s
dourine8311453douri_ne
dourines9311373dourines
drabs85119673d_r_abs
drags75521113d_r_ags
drails74716953d_rails
drain65222893d_rain_
drams86025833d_r_ams
drank104816203d_r_ank
drats66628373d_r_ats
draws95119373d_r_aws
drays95819773d_r_ays
dreads84115023d_reads
dreams94513983d_reams
drears74614253d_rears
dribs85115063d_ri_bs
driers74516733d_riers
dries64733673d_ri_es
drifts10499893d_rifts
drills74414203d_rills
drink106816383d_ri_nk
drinks116810713d_rinks
drips85417233d_ri_ps
drives105117113d_rives
drowns105612333d_rowns
druids8368093drui_ds
dryads11436623d_ryads
duads76515343du__ads
duals65620083du__als
dubbins12358803dubbins
dubious1036893dubious
ducats95011763du_cats
dudeens934863dudeens
duding93913323dudi_ng
duennas834143duennas
duits65021883du_i_ts
duking124715133duki_ng
dulciana1142573dulciana
dulcianas1241903dulcianas
dulia61014983dulia__
dumas85420433du_ma_s
dunams937833du_nams
dunites8313593dunites
dunlins849553dunlins
duns55140433du___ns
duping104113633dupi_ng
dura55232113dur_a__
dural64923893dur_a_l
duramens1195153duramens
durance1059113dur_ance
durances1158683dur_ances
durations10311463durations
durbar968723durba_r
dures65635923dur__es
duress74712063dur_ess
durmast1037623durmast
durmasts1144093durmasts
durn56127623dur__n_
durning93511733durning
durocs9569703dur_ocs
duros65422693dur__os
durra65315793durra__
durries83817353durries
durrs65519993dur__rs
durums948153dur_ums
dustpans1143233dustpans
duties74921903duti_es
dysurias1244463dysuria_s
euripus934623euripus
farinas103215233farinas
ferias95020393feria_s
firmans12238523firmans
friars93812093_friars
furan84320013fur_an_
furane94015493fur_ane
furanes103214863fur_anes
furies95126373furi_es
furious103110633furious
fusains1038363fusains
fusions1039153fusions
fustians1146403fustians
germans1079473germans
grains74223093_grains
grans64832543_gr_ans
grins65427223_gri_ns
groans74815063_groans
guaiacs1054353guaiacs
guans64419443gu__ans
guardians1143913guardians
hariana10310243hariana
harianas1139163harianas
harijans1845723harijans
humans112312433hu_mans
hurrahs13336773hurrahs
hurrays13386153hurrays
jarinas143712183jarinas
jordans1566833jordans
jurant134216553jur_ant
jurants14379213jur_ants
jurats134213203jur_ats
juries134120633juri_es
jurists14409123jurists
kalians11310183kalians
kurgan11126783kurgan_
kurtas10349883kurta_s
lariats7615053lariats
lorans65117603lor_ans
lunarians945513lunarians
lungans8399053lungans
lupins84514463lupi_ns
lurdan738363lurdan_
lurdane835983lurdane
lurdanes936063lurdanes
luring73820753luri_ng
magians10310753magians
marinas93519383marinas
martians103111613martians
medians103214213medians
mirins83918903miri_ns
morgans10310123morgans
morions94014643morions
mucins102712513muci_ns
murals84016753mur_als
muras75329563mur_a_s
mureins9310733mureins
muriate9313363muriate
muriates10312083muriates
murices112612283murices
murids93212193muri_ds
murine84220023muri_ne
murines93718223murines
muring95120373muri_ng
murrains1036853murrains
murras84916003murra_s
myriads1334353myriads
norias65518203noria_s
nubias8310093nubia_s
nutrias739813nutria_s
organs7912913_organs
origans839973_origans
ourang73311063our_ang
ourangs8318503our_angs
outmans92413283outmans
pagurians1243393pagurians
pariahs123812343pariahs
parian83223963parian_
partans94418283partans
pians75126963__pians
prions84317783_prions
purana8712933pur_ana
puranas9712643pur_anas
purdahs13285483purdahs
purdas92612263purda_s
purin75527593puri_n_
purine85321893puri_ne
purines94420763purines
puris75332023puri__s
purisms114110833purisms
purists94014073purists
puritan939283puritan_
purlins93415423purlins
pyrans11411063pyr_ans
pyurias1236713pyuria_s
quartans1736283quartans
queans153110753qu_eans
quins144819853qu_i_ns
quoins154110583quoi_ns
radians83013823radians
rains55140233__rains
rials55026673__rials
riant55833153__riant
rias45540593__ria_s
rins46153193__ri_ns
roans54926443__roans
ruffians1443793ruffians
ruins55822033ru_i_ns
rupiahs1253333rupiahs
rurban849043rurban_
rutins63818393ruti_ns
sarans64224433sar_ans
sarins63932623sari_ns
saurian739913saurian_
serials73919743serials
serins64029673seri_ns
simians959203simians
sprains93013593sprains
strains74218153strains
suldans8299723suldans
sultans72411833sultans
suntans72111733suntans
surahs94515543sur_ahs
suras55336323sur_a_s
surimis938843surimis
surpass938283surpass
surras65919533surra_s
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
tertians839103tertians
therians1138313therians
titians72710453titians
trains64725343_trains
trans54933043_tr_ans
triacs83913223_triacs
triads74513533_triads
trials64319883_trials
triens65417543_triens
turban8310483turban_
tureens7289873tureens
turion6313163turion_
turnons737863turnons
turns55623233tur__ns
uhlans937573_uhlans
ulans54921303_u_lans
umiacs1035663_umiacs
umiaks1244953_umiaks
umiaqs1733003_umiaqs
unbans81912623_unbans
unions64216753_unions
unmans82211993_unmans
urban72013863_urban_
urbane82211383_urbane
urbias839093_urbia_s
ureas55826013_urea_s
urial54823023_uria_l
urinal6614123_urinal
urinals7610253_urinals
urine55026593_uri_ne
urines64724123_urines
urns46323893_ur__ns
variant10316803variant
variants1139203variants
varias95019903varia_s
virions1039873virions
yuans84613323yu__ans
yulans958673yu_lans

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.1561145455.1
2DLD Change Limit1340273736.95319276.1
3Display Results3733730.1233032.5
 (SQL Overall)1786913737.23224708.4
 
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.