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

147 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
curiosa934664(None) 
curios83218331curios_
carioca1139682carioca
crissa837622c_rissa
curia74523772curi__a
curies84934022curies_
curio74221212curio__
curious93813562curious
furioso1044322furioso
ariose64818723_ariose
ariosi64313033_ariosi
arioso64312403_arioso
audios72312283audios_
aureola747033aureola
auris55331533auri_s_
aurist65027253auri_st
aurora6411763aur_ora
brios74725723_brios_
buries84633273buries_
burins84221893burins_
burros85114993burros_
bursa74921523bur__sa
camisa103114323cami_sa
carbora11310703carbora
carbos105122263carbos_
cargos94619183cargos_
caries85147623caries_
carina84325323cari_na
carinas93622403carinas
cariocas1239663cariocas
cariole9818343cariole
carious93320283carious
caritas93316953caritas
ceria75125353ceri__a
cerias83321983cerias_
cerise84822043ceri_se
ceros74726073cer_os_
chiros114617773chiros_
chrism13710673chri_sm
chrisma1456823chrisma
chrisom1466623chrisom
chroma132912473chr_oma
churros12427583churros_
cirrose937473cirrose
cordoba1255743cordoba
coria75828323cori__a
corona83817403cor_ona
corpora1139353corpora
cribs94516753c_ribs_
cries75438403c_ries_
cris66233433c_ri_s_
crisp95014623c_ri_sp
crissal937413c_rissal
crista8311803c_rista
crits75527573c_rits_
cross75124503c_r_oss
cruise84314043crui_se
cubics123810163cubics_
cubism12348703cubi_sm
cubist104214443cubi_st
cubits103714033cubits_
cuifs104814693cu_ifs_
cuirass934973cuirass
cuish10313173cu_i_sh
cuisse8318333cu_isse
cumins103314933cumins_
cupids11369193cupids_
cupola10317693cu_pola
curacoa1146223curacoa
curacoas1246033curacoas
curara83712203cur_ara
curaras93911953curaras
curbs94821653cur_bs_
curcuma1344773curcuma
curdiest112511393curdiest
curds85725613cur_ds_
curers84923193curers_
cures75645433cur_es_
curets84922343curets_
curfs105122143cur_fs_
curiae84518373curi_ae
curial84019153curi_al
curie74533043curi__e
curing94824783curi_ng
curiosity1444543curiosity
curiouser1153433curiouser
curiously1447673curiously
curite85222943curi_te
curites93919863curites
curium10312503curi_um
curiums1138503curiums
curliest102713123curliest
curls74927103cur_ls_
curns74924283cur_ns_
curries93723163curries_
currish1238353currish
currs75624393cur_rs_
curs65645543cur__s_
curse75829143cur__se
curses85328273curses_
cursor84110293curso_r
cursors93910023cursors
cursory12406393cursory
curst74931023cur__st
curtest9713963curtest
curtesy1265833curtesy
curtsy1156643cur_tsy
curves114619283curves_
curviest13309673curviest
cussos84210003cussos_
custos84014313custos_
cuties84927363cuties_
cutins83919983cutins_
cutis77723763cuti_s_
durion7510963durio_n
durions839963durions
duros65422693dur_os_
euros54920243eur_os_
fugios1037583fugios_
furies95126373furies_
furious103110633furious
guiros7389093guiros_
harissa1035503harissa
juries134120633juries_
jurist134616393juri_st
mariposa1243703mariposa
mucosa10166273mu_cosa
murids93212193murids_
purins83722653purins_
puris75332023puri_s_
purism104715063puri_sm
purist85525053puri_st
purpose1137383purpose
rioja1236303__rioja
rugosa734563ru_gosa
scabiosa1262853scabiosa
scariose1037593scariose
serosa6313023ser_osa
trios55528093_trios_
triose64715383_triose
turbos8910783turbos_
turion6313163turio_n
turions7311573turions
turista737443turista
urinose738483_urinose
ursa44116913_ur__sa
variola1068893variola

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.420425454.8
2DLD Change Limit1340271477.00019146.7
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.48323879.6
 
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.