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

44 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
dhourras125223(None) 
dhourra1152021dhourra_
dhooras1135942dho_oras
dhurnas1153442dh_urnas
douras75016722d_ou_ras
durras74713372d__urras
choleras13289043choleras
choreas124414203cho_reas
churros12427583ch_urros
churrs115111513ch_urr_s
daturas838783datu_ras
demurral1143943demurral
demurrals1243023demurrals
deodaras1044693deodaras
dharmas1356513dh_armas
dharnas1155373dh_arnas
dhoora1035653dho_ora_
dhurna1043563dh_urna_
dhurrie1153953dh_urrie
dhurries1255583dh_urries
dobras94811913d_o_bras
dorrs65520593d_o_rr_s
doulas75114993d_ou_las
doumas95314813d_ou_mas
doura66518663d_ou_ra_
dourah10479813d_ou_rah
dourahs11487253d_ourahs
droseras935873droseras
duras65727733d__u_ras
durra65315793d__urra_
durrs65519993d__urr_s
dysurias1244463dysurias
horas86333103_ho__ras
houris94514583_hou_ris
hours85422393_hou_r_s
hurrah12369183_h_urrah
hurrahs13336773_h_urrahs
hurray12459913_h_urray
hurrays13386153_h_urrays
murras84916013__murras
rhodoras1244453rhodoras
surras65919533__surras
thioureas12112813thioureas
thorias102312053tho_rias

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 Filter1786911461620.420425454.8
2DLD Change Limit146162446.23623438.4
3Display Results44440.0133384.6
 (SQL Overall)178691446.66926794.3
 
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.