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

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

58 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
crura731258(None) 
crural8610631crural
aura45836252_aura
bura66139532_bura
cesura838762cesura
chufa13489112chufa
churl105913882churl
churn105113102churn
churr104512852churr
cobra95214402cobra
copra98115462copra
court75532772court
crore74922872crore
cru57129562cru__
cruck135615322cruck
crud75219612cru_d
crude86018572crude
cruds85815852cruds
cruel74815902cruel
cruet74831842cruet
crumb114313592crumb
crump115616422crump
cruor7310452cruor
cruors838642cruors
crus65828482cru_s
cruse75726102cruse
crush106815992crush
crust75827662crust
crux135415002cru_x
cur56841982c_ur_
curara83712202curara
curb86732222c_urb
curd77634982c_urd
cure66149122c_ure
curf97538782c_urf
curia74523772curia
curl66035052c_url
curn66731892c_urn
curr65429652c_urr
curran8312022curran
currs75624392currs
curry105920342curry
curs65645542c_urs
curt67051712c_urt
doura66518662doura
dura55232112_dura
durra65315792durra
jura116024892_jura
laura54116202laura
mura65633302_mura
murra74519082murra
orra46120722or_ra
parura8310582parura
pruta7314242pruta
ruga56121232_ruga
rural55821172_rural
sura45740292_sura
surra55521342surra

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit53800581.67032215.6
3Display Results58580.0163625.0
 (SQL Overall)178691581.99989390.2
 
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.