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

66 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
jereed14401206(None) 
jeered143912791jeered
jereeds15326381jereeds
jerked18479591jerked
jerreed1535201jerreed
aeried74221862aeried
agreed84712502agreed
bermed115217722bermed
breed85526692_breed
cered85227442cer_ed
creed85727392_creed
decreed112710252decreed
degreed10258882degreed
dreed75222842_dreed
erred65915672_erred
freed95223542_freed
greed75125692_greed
herbed123513452herbed
herded114215642herded
jarred144613252jarred
jeaned143813462jeaned
jeed125428502j__eed
jeeped16469842jeeped
jeerer13389932jeerer
jelled144916062jelled
jerid132316422jer_id
jerker17369042jerker
jerreeds1653262jerreeds
jerrid14259142jerrid
jersey1636332jersey
jerseyed1942732jerseyed
jessed144112302jessed
jested144416502jested
jetted143915082jetted
jewed165114832je_wed
jeweled1845322jeweled
juried144212442juried
kerbed13339692kerbed
kerfed14358222kerfed
kerned114112922kerned
leered73816222leered
leveed104111372leveed
merged104214942merged
nereid7312922nereid
nerved104111682nerved
peered93819482peered
perked134617682perked
permed115217342permed
preed85128112_preed
pureed95017802pureed
rebreed104611072rebreed
reed55549622__reed
refeed104717622refeed
reread71715432reread
reseed74823292reseed
screed95718922screed
sered65737292ser_ed
serged84118762serged
served104616812served
termed94816702termed
treed65626732_treed
veered103612742veered
verged114815152verged
versed104515512versed
yerked14509372yerked
zeroed16409412zeroed

Search took 4 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 Filter178691825510.206867432.0
2DLD Change Limit82551663.01327398.3
3Display Results66660.0461434.8
 (SQL Overall)178691663.26554729.2
 
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.