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

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

65 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
walkover184294(None) 
walkovers1942611walkovers
allover1038582_allover
walker133913992walk__er
walloper13147112walloper
wallower14158932wallower
alcove1178083_alcove_
alcoved1375613_alcoved
alcoves1297873_alcoves
allovers1137673_allovers
almoner949383_almoner
balker124519163balk__er
balkier134111983balk_ier
balloter1078893balloter
calker124917083calk__er
callower13159073callower
caloyer1238143cal_oyer
clover114617123_cl_over
falconer1346033falconer
flyover1633513_flyover
galloper11137183galloper
glover104513533_gl_over
hallower14139813hallower
handover15126823handover
hangover15134433hangover
holdover1544083holdover
layover1334433la_yover
lover85526453__l_over
makeover17113353makeover
palaver1238753pal_aver
passover13135533passover
plover115312613_pl_over
pullover13134643pullover
rollover1144453rollover
sallower11139503sallower
salver94617753sal__ver
swallower1554333swallower
takeover15113693takeover
talker103916223talk__er
talkier114011843talk_ier
wacker154920123wack__er
wackier16369733wack_ier
waggoner1343423waggoner
wagoner1136093wa_goner
waiver124212713wa__iver
wakener1446913wa_kener
waker125526593wa_k__er
waler84229263wal___er
walked145313783walk__ed
walkers143411473walk__ers
walkout1447933walko_ut
walkouts1544253walkouts
walloped14146833walloped
wallopers14136273wallopers
wallowed15148163wallowed
wallowers15127653wallowers
waltzer1934383wal_tzer
wanker134219973wank__er
wantoner1187563wantoner
warpower1645043warpower
waver115025703wa___ver
welcomer1544023welcomer
willower14127453willower
wingover1544303wingover
wolver12419713wol__ver

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit146162656.73621698.6
3Display Results65650.0135000.0
 (SQL Overall)178691657.16924925.5
 
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.