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

200 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
churros1242758(None) 
charros124312141charros
churro11448351churro_
churrs115111511churr_s
burros85114992_burros
charro114212952charro_
charrs115219192charr_s
cheeros123711632cheeros
chiros114617772ch_iros
chirres123812252chirres
chirrs114514982chirr_s
churls115411072chu_rls
churns114910232chu_rns
churr104512852churr__
churred13409172churred
curios83218332c_urios
currs75624392c_urr_s
burro75018493_burro_
burrow114610803_burrow
burrows12399093_burrows
burrs74925653_burr_s
carbos105122263c_arbos
cargos94619183c_argos
carrom10513403c_arrom
carroms11512403c_arroms
carrot8423123c_arrot
carrots9714623c_arrots
carrs75730853c_arr_s
ceros74726073c__eros
chadors1338753chadors
chairs114916183chair_s
chakras16428503chakras
chaos105622863ch__aos
charas114223613ch_aras
chards125119733ch_ards
chares115631803ch_ares
charges134615983charges
chariot12316213chariot
chariots1339393chariots
charkas164810963charkas
charks155219703ch_arks
charms135218843ch_arms
charpoy1735713charpoy
charpoys1834533charpoys
charr104821783charr__
charred134614483charred
charry145012113charr_y
chars105936643ch_ar_s
charts115823093ch_arts
cheapos14418513cheapos
cheerios13317583cheerios
cheero114712933cheero_
cheers114518913cheer_s
chemos13311723ch_emos
cheroot12413693cheroot
cheroots1348193cheroots
cherries131812983cherries
cherry144810763cherr_y
cherts115617233ch_erts
cherubs1434553cherubs
chevres15379793chevres
chevron1575783chevron
chevrons1665463chevrons
chicos134614833ch_icos
chinos115018693ch_inos
chirks155414843ch_irks
chirms135113983ch_irms
chiro105320343ch_iro_
chirps135414003ch_irps
chirr105015903chirr__
chirre114111853chirr_e
chirred133612123chirred
chirren12388743chirren
chirrup14123833chirrup
chirrups15133043chirrups
chirus114615693ch_irus
chlorous1339223chlorous
choirs114911883choir_s
cholos114716853ch_olos
chorals124614113chorals
chords125214633ch_ords
choreas124414203choreas
chores114828023ch_ores
chorion12311773chorion
chorions13310663chorions
chorizos2245493chorizos
chorus115014773ch_orus
chromos142610273chromos
chubs125412623chu__bs
chucks174812933chu_cks
chufas14397673chu_fas
chuffs17427783chu_ffs
chugs115511943chu__gs
chukars1634283chukars
chukkas1532783chukkas
chumps154313823chu_mps
chums125015833chu__ms
chunks154210333chu_nks
chuppas1644123chuppas
church1636483chu_rch
churches1846433churches
churchy2044183churchy
churl105913883chu_r_l
churlish1644903churlish
churn105113103chu_r_n
churned13358373churned
churner12298343churner
churners13316893churners
churring14298653churring
chutes114615773chu_tes
ciceros1158593ciceros
cirrose937473c_irrose
cirrous93111063c_irrous
cirrus8349173c_irrus
claros84015113c_laros
courses94218893courses
courts84216173cou_rts
cruors838643cruor_s
cuatros938273cuatros
cuprous1149743c_uprous
curaras93911953c_uraras
curares94916853c_urares
curaris94114773c_uraris
curbs94821653c_u_rbs
curds85725613c_u_rds
curers84923193c_urers
cures75645433c_u_res
curets84922343c_urets
curfs105122143c_u_rfs
curies84934023c_uries
curio74221213c_urio_
curiosa9346643c_uriosa
curious93813563c_urious
curls74927103c_u_rls
curns74924283c_u_rns
curr65429653c_urr__
curran8312023c_urran
currans9310613c_urrans
curred94319263c_urred
currie84317263c_urrie
curries93723163c_urries
currish1238353c_urrish
curry105920343c_urr_y
curs65645543c_u_r_s
curses85328273c_urses
cursor84110293c_ursor
cursors93910023c_ursors
curves114619283c_urves
cussos84210003c_ussos
custos84014313c_ustos
dhourras1252233dhourras
dhurnas1153443dhurnas
dhurrie1153953dhurrie
dhurries1255583dhurries
duros65422693_du_ros
durras74713373_durras
durrs65519993_durr_s
euros54920243_eu_ros
furors9310953_furors
furrow12427743_furrow
furrows13327793_furrows
gharris11306433gharris
guiros7389093_guiros
harrow122610773_harrow
harrows132611033_harrows
heros84930863_h_eros
horror988723_horror
horrors1078693_horrors
hubris11218973_hubris
hullos94916293_hullos
humors11129633_humors
hurds95219073_hu_rds
hurls86522713_hu_rls
hurrah12369183_hurrah
hurrahs13336773_hurrahs
hurray12459913_hurray
hurrays13386153_hurrays
hurries103919653_hurries
hurry114917183_hurr_y
hursts97213093_hursts
hurts86922823_hu_rts
hydros13279363_hydros
journos14134943journos
jurors1338283_jurors
kouros1039183kou_ros
morros83714673_morros
murras84916013_murras
murres85019043_murres
murrs75521303_murr_s
pharos11312063ph_aros
purrs75320433_purr_s
sahuaros1154283sahuaros
scherzos2243703scherzos
sherris10168803sherris
shirrs94413173shirr_s
surras65919533_surras
thermos124610753thermos
thurls9418713thu_rls
turbos8910783_turbos
whirrs12408593whirr_s

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.453394461.4
2DLD Change Limit1340272007.14018771.3
3Display Results2002000.0762631.6
 (SQL Overall)1786912007.66923300.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.