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

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

148 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
wyte10601864(None) 
byte96521811byte
hyte109018941hyte
kyte117017761kyte
wite75443271wite
wye96331971wy_e
wyle105519381wyle
wyted12529471wyted
wytes114113431wytes
ante46538902ante
ate37059242_ate
aye67151762ay_e
bate66552422bate
bite66547002bite
bute66739672bute
bye86134592by_e
byre95023852byre
bytes105217492bytes
cate66254592cate
cete64934782cete
cite65640342cite
cote66648732cote
cute66440452cute
cyme119420372cyme
date56443322date
dite55547552dite
dote55442882dote
dye75334842dy_e
dyke126418182dyke
dyne85320932dyne
eye65539772ey_e
eyne76322462eyne
eyre75525252eyre
fate75444282fate
fete75734922fete
flyte115713942flyte
fyce126316832fyce
fyke145915292fyke
fytte1138582fytte
gate55746572gate
gite55438612gite
gybe105916242gybe
gyre84722762gyre
gyve116215082gyve
hate78450172hate
hype125519812hype
jete115927252jete
jute115327892jute
kite85338232kite
kye107327272ky_e
kytes125012912kytes
kythe15509672kythe
late47560482late
lite47054542lite
lute46341012lute
lye66533412ly_e
lyre75623792lyre
lyse76320592lyse
mate65154212mate
mete64438132mete
mite66249412mite
mote67048082mote
mute65136872mute
myth126715432myth
nite45943582nite
note46239962note
pate65350462pate
pye86432502py_e
pyre94925552pyre
rate45458762rate
rete44944132rete
rite45849452rite
rote46249022rote
rye66032542ry_e
ryke115616402ryke
sate45556102sate
site47052412site
stye76218972stye
syce95820282syce
syke115420562syke
syne75725762syne
tate44748602tate
tote46643672tote
tye65837442ty_e
tyee75131422tyee
tyke115720502tyke
tyne76325052tyne
type96223742type
tyre75428252tyre
tythe115210452tythe
ute35335882_ute
vote74728622vote
wade85237062wade
wae67556952w_ae
wage84834082wage
wake114935702wake
wale74546432wale
wame95035482wame
wane76344712wane
ware76254722ware
waste86125052waste
wat67378922wat_
water84733312water
wats77555882wats
watt75545412watt
wave105234732wave
we57043452w__e
wee66760812w_ee
weet75254152weet
were76238332were
wet65966622wet_
wets75940292wets
whee105429592whee
whet105133782whet
white114920302white
wide85235402wide
wife105228022wife
wile75944372wile
wine74953422wine
wipe94830282wipe
wire75839812wire
wise75737342wise
wit66563772wit_
wited94727142wited
wites85536962wites
with105730472with
withe115220232withe
wits76044872wits
wive105931752wive
woe66651242w_oe
woke115527962woke
wore77144672wore
wot610467482wot_
wots76342892wots
wove105624312wove
write85522832write
wrote84717482wrote
wych154011882wych
wyes105727502wyes
wyled124611842wyled
wyles114615322wyles
wyn95921442wy_n
wynd116114462wynd
wynn105811292wynn
wyns105717032wyns
ye57650062_y_e
yet66960692_yet
zyme1819114942zyme

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 Filter178691298720.0762351197.4
2DLD Change Limit298721480.93631914.5
3Display Results1481480.0334484.8
 (SQL Overall)1786911481.045170996.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.