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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

92 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
oyez16602035(None) 
oyer75927651oyer
oyes74940131oyes
aye67151762aye_
ayes76543512ayes
bye86134592bye_
byes95230532byes
chez184519022chez
coyed114623802coyed
coyer105222842coyer
doyen95014412doyen
dye75334842dye_
dyed96720762dyed
dyer85522112dyer
dyes85331892dyes
eye65539772eye_
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyes75837882eyes
fez156236822_fez
foyer116416552foyer
geez146424862geez
jeez205622032jeez
joyed164811832joyed
kye107327272kye_
kyes115124932kyes
lez125541312_lez
lye66533412lye_
lyes75530832lyes
obe56638642obe_
obes66036832obes
obey96521302obey
ode47446582ode_
odea56224572odea
odes57243242odes
oe28473062o_e_
oes35866192o_es
ogee57629882ogee
ohed87825182ohed
oke75839482oke_
okeh114615322okeh
okes84936342okes
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
omen66828182omen
omer67028392omer
one37050912one_
ones46146532ones
ooze136420602ooze
ope56845242ope_
oped76230152oped
open66427002open
opes65942612opes
ore36661832ore_
ores46056682ores
ose38147342ose_
oses46641512oses
oven76624142oven
over77227342over
owe67041032owe_
owed86833872owed
owes75137102owes
oxen116218592oxen
oxes116530722oxes
oy58950132oy__
oyers87620882oyers
oyezes1835052oyezes
prez156126312prez
pye86432502pye_
pyes95528992pyes
rye66032542rye_
ryes75529352ryes
soyuz1748852soyuz
toyed96019802toyed
toyer84521552toyer
tye65837442tye_
tyee75131422tyee
tyer75323392tyer
tyes76433372tyes
wye96331972wye_
wyes105727502wyes
ye57650062_ye_
yea66445752_yea
yeh97135772_yeh
yen66847382_yen
yep86638962_yep
yes66250612_yes
yet66960692_yet
yew96436292_yew

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.283631417.0
2DLD Change Limit29872920.78038297.4
3Display Results92920.0165750.0
 (SQL Overall)178691921.079165608.0
 
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.