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

80 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
sadhe9481513(None) 
sade55544471sad_e
sadhes104715371sadhes
sadhu9459961sadhu
sidhe95315101sidhe
ache96829822_ache
adze1412820572_adze
bade75140882bad_e
badge94819682badge
bathe105822882bathe
cache125122482cache
cade76443912cad_e
cadge94018782cadge
cadre85419012cadre
fade85736342fad_e
fadge104816992fadge
gadje1457742gadje
hade85440192had_e
jade125325442jad_e
lade56345982lad_e
ladle66320442ladle
lathe85626712lathe
mache125925302mache
made75440232mad_e
madre85720172madre
padle84522342padle
padre86018162padre
raphe104916422raphe
rathe85821922rathe
sabe66140572sa_be
sable74732162sable
sabre74821502sabre
sachem134012222sachem
sachet114725772sachet
sad47459202sad__
sadden83212402sadden
sadder82916972sadder
saddhu1133412saddhu
saddle83915492saddle
sades65239892sades
sadhus10298462sadhus
sadi55834642sad_i
sadis64930852sadis
sadly94519122sadly
sae38365182sa__e
safe75930952sa_fe
sage55044592sa_ge
saice75424052saice
saithe94713912saithe
sake85244962sa_ke
sale44959702sa_le
salve85022132salve
same65245642sa_me
sandhi1038192sandhi
sane45954332sa_ne
saree55044662saree
sarge65531132sarge
sash77235302sash_
sashed105622942sashed
sashes94728482sashes
sate45556102sa_te
sauce75121652sauce
saute55028082saute
save75741362sa_ve
scathe114414992scathe
sedge75019952sedge
shade95125582shad_e
she66837692s__he
side55444482sid_e
sidh86222982sidh_
sidle65124032sidle
snathe94415112snathe
spade84423322spad_e
spathe115115692spathe
sradha1085332sradha
stade64825302stad_e
swathe125514112swathe
tache106222372tache
tsade64311122tsad_e
wade85237062wad_e

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.0931921408.6
2DLD Change Limit53800801.89328420.5
3Display Results80800.0136153.8
 (SQL Overall)178691801.99989390.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.