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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
flysch173289(None) 
flash115716212flas_h
fleech14367342fleech
flench144010812flench
flesh115013742fles_h
fletch14388192fletch
flinch144010102flinch
flitch14928172flitch
flush115116072flus_h
flysches1933122flysches
lych126015762_ly_ch
lynch13468982_lynch
blanch133410853blanch
bleach133611403bleach
blench133710453blench
blotch13197143blotch
blush105115313blus_h
borsch1336133borsch
clach124617823cl_ach
clash106219033clas_h
clench133910053clench
clinch133910353clinch
clutch13367753clutch
fash107232293f_as_h
fays108535363fays__
fetch134913473f_etch
fetich1479693fetich
fiaschi1542793fiaschi
fiasco11104923fiasco
filch134813323f_ilch
finch135416973f_inch
fisc96819753f_isc_
fiscs105311883f_iscs
fish106926273f_is_h
fitch134816873f_itch
flack144519413fl_ack
flashy15498173flashy
flask125512423flas_k
flasks13488673flasks
flays116321053flays__
fleche14299303fl_eche
fleck148213593fl_eck
fleece11369903fleece
fleecy14266483fleecy
fleshy15406283fleshy
fleys117015603fleys__
flic96223733fl_ic_
flick145017213fl_ick
flics105418363fl_ics
floc95922123fl_oc_
flocci1335023flocci
flock144717423fl_ock
flocs105519233fl_ocs
floss85118263flos_s
flossy12517703flossy
fluish1239333fluish
flus75626543flus__
fly97124953fly___
flyboy17113913flyboy
flyby1676003fly_by
flybys1792773flybys
flyer114916253fly_er
flyers125712803flyers
flying134612153flying
flyman14326423flyman
flymen14387773flymen
flyoff1444023flyoff
flyspeck2241263flyspeck
flyte115713943fly_te
flyted13378773flyted
flytes123911563flytes
flyway18134693flyway
foys105628293foys__
french143511213french
fresco1136473fresco
fresh115012203fres_h
frosh115713403fros_h
fyce126316833f_y_ce
glitch12286353glitch
glunch1255353glunch
glyph1456473gly_ph
kirsch1532713kirsch
kitsch1533353kitsch
klatch15445933klatch
klatsch1651683klatsch
laich105920713_laich
larch105919793_larch
lash76539653_las_h
latch104620463_latch
leach105422523_leach
lech96825443_l_ech
leech104913213_leech
letch105215803_letch
lich96230843_l_ich
loach105116363_loach
loch95527133_l_och
lunch104917243_lunch
lurch104814633_lurch
lush75327693_lus_h
lymph1547043_lymph
lyse76320593_lys_e
lysed95011563_lysed
lyses84518253_lyses
lysin84512783_lysin
lysis84511463_lysis
lyssa835713_lyssa
mensch13387103mensch
planch133711443planch
plash104616563plas_h
pleach134211243pleach
plench134010813plench
plush105614713plus_h
psych1554963psy_ch
putsch1334933putsch
slash84719683slas_h
slatch114510533slatch
slosh84514483slos_h
slouch11438523slouch
slush85316573slus_h
synch135011793_synch
wych154011883_wy_ch
yech127220533__yech
yuch125818533__yuch

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit1127161234.90622975.1
3Display Results1231230.0462673.9
 (SQL Overall)1786911235.31233639.1
 
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.