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

76 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
crumb11431359(None) 
crumbs12409231crumbs
crumby15408111crumby
crump115616421crump
arum66129032arum_
arums75517832arums
brumby15385952brumby
brume95817982brume
chimb144813562chimb
chub115516412chu_b
chum116318002chum_
chump145315442chump
chums125015832chums
climb115413592climb
clomb115714702clomb
club85819472clu_b
clump115517452clump
comb106632112c_omb
coomb115615702coomb
corymb1535222corymb
crab85727672cr_ab
cram85635492cram_
crambe1239072crambe
crambo1238042crambo
cramp115120692cramp
crams96229152crams
creme94319322creme
crib86323582cr_ib
crime94822692crime
crimp115615802crimp
cru57129562cru__
cruck135615322cruck
crud75219612cru_d
crude86018572crude
cruds85815852cruds
cruel74815902cruel
cruet74831842cruet
crumbed14378472crumbed
crumber13339642crumber
crumble133410402crumble
crumbly16347522crumbly
crumbum1543742crumbum
crummy15365892crummy
crumps124514342crumps
cruor7310442cruor
crura7312582crura
crus65828482cru_s
cruse75726102cruse
crush106815992crush
crust75827662crust
crux135415002cru_x
cub76940942c_u_b
cum76440162c_um_
curb86732222c_urb
drub75920132dru_b
drum76521592drum_
drums85415872drums
dumb97124102_dumb
frump126912562frump
grub77220082gru_b
grum75625082grum_
grume86218162grume
grump105115312grump
numb85520612_numb
plumb114514072plumb
rhumb12438652rhumb
rub56342822_ru_b
rum56644642_rum_
rumba93612512_rumba
rump86729082_rump
rums64833472_rums
scrub94914202scru_b
scrum95418192scrum_
scrums104614252scrums
thumb124511282thumb
trump95615122trump

Search took 2 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.0931921408.6
2DLD Change Limit53800761.34340059.6
3Display Results76760.0164750.0
 (SQL Overall)178691761.452123065.4
 
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.