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 “dhourra” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

51 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
dhourra115202(None) 
dhourras1252231dhourras
dhoora1035652dho_ora
dhurna1043562dh_urna
doura66518662d_ou_ra
durra65315792d__urra
cholera12409093cholera
chorea115216083cho_rea
churr104512853ch_urr_
churro11448353ch_urro
churrs115111513ch_urrs
datura738023datu_ra
demurral1143943demurral
deodara945243deodara
dharma1276103dh_arma
dharna1055263dh_arna
dhooras1135943dhooras
dhurnas1153443dh_urnas
dhurrie1153953dh_urrie
dobra85013103d_o_bra
dorr56627723d_o_rr_
dorrs65520593d_o_rrs
dorsa64617283d_o_rsa
doula65717773d_ou_la
douma85817703d_ou_ma
dour56330433d_ou_r_
dourah10479813d_ourah
douras75016723d_ouras
dourer74215273d_ourer
dourly103210433d_ourly
drosera836203drosera
dura55232113d__u_ra
durr55624353d__urr_
durras74713373d__urras
durrs65519993d__urrs
dysuria1144923dysuria
hora76136553_ho__ra
hour75827313_hou_r_
houri85915243_hou_ri
houris94514573_houris
hourly12369623_hourly
hours85422393_hou_rs
hurrah12369183_h_urrah
hurray12459913_h_urray
hurry114917183_h_urry
murra74519083__murra
orra46120723__o_rra
rhodora1144293rhodora
surra55521343__surra
thiourea1193073thiourea
thoria93012883tho_ria

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 Limit134027517.39018136.3
3Display Results51510.0133923.1
 (SQL Overall)178691517.55923639.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.