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

232 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
forwhy183442(None) 
foray115023972for_ay
forby135317672for_by
foreby1438632foreby
forky156119642for_ky
forth116222672forth_
forty114824272for_ty
frothy15578372frothy
frowsy15498272frowsy
frowzy24485792frowzy
torchy14549532torchy
worthy15598802worthy
airway1237693airway
bolshy1444883bolshy
borsht11813503borsht
borty105522833bor_ty
botchy16537823botchy
bothy136713963bo_thy
brothy14519623brothy
browny144510043browny
cogway1566183cogway
conchy163710223conchy
corby125018533cor_by
corky145221153cor_ky
corny106023273cor_ny
corody12149703corody
cory96941513cor__y
cowry135512483co_wry
cowy126427363co_w_y
crowdy15467173crowdy
doorway1444243doorway
dorky135518743dor_ky
dormy115817473dor_my
dorty96220813dor_ty
dory85836233dor__y
doughy14499843doughy
dowdy136112543do_wdy
downy125714553do_wny
dowry126312483do_wry
drowsy13487903drowsy
earthy12399943earthy
fairway1644333fairway
faraway1645413faraway
farcy135217093far_cy
fawny144711713f_awny
ferity122813343ferity
ferly115517353fer_ly
ferny115816183fer_ny
ferry116020803fer_ry
filthy15356423filthy
firmly1436663firmly
firry115713533fir_ry
firth115819533firth_
firths125113503firths
fishy146011663f_ishy
fitchy17437623fitchy
flashy15498173flashy
flawy145913383flaw_y
fleshy15406283fleshy
flyway18134693flyway
foamy135313203fo_amy
foehn11236323fo_ehn
fogey125617873fo_gey
foggy136714543fo_ggy
fogy115923183fo__gy
foh98135893fo__h_
fohn106116553fo__hn
foley115222303fo_ley
folksy16484983folksy
folkway2043353folkway
folky159214713fo_lky
folly115022603fo_lly
fondly13299043fondly
footsy12587933footsy
footway1635253footway
footy115820533fo_oty
for66952073for___
fora75937393for__a
forage104617003forage
foram105124933for_am
forams115115913forams
forays124813003forays
forb97131333for__b
forbad122710503forbad
forbid123312433forbid
forbs105720803for_bs
forbye14427883forbye
force105324273for_ce
forced126316523forced
forcer114917343forcer
forces114422133forces
ford86835493for__d
forded115020393forded
fordid113512053fordid
fordo97218653for_do
fords95328183for_ds
fore78351473for__e
forebay1538133forebay
forebye1536353forebye
foredo10510823foredo
forego1038903forego
fores85847103for_es
forest94926743forest
forgat104018583forgat
forge95126943for_ge
forged115519323forged
forger104820773forger
forgery14419303forgery
forges105024263forges
forget106326393forget
forgo94418333for_go
forgot104318133forgot
forint9325023forint
fork115930943for__k
forked145217143forked
forker134717903forker
forks125324683for_ks
form95836873for__m
formal113215203formal
format113021353format
forme105225993for_me
formed125021173formed
formee113919943formee
former114221403former
formes114623713formes
formic13310453formic
formol112910333formol
forms105327053for_ms
formyl14276443formyl
fornix1636033fornix
forrit91916623forrit
fort76456443for__t
forte86131463for_te
fortes95327183fortes
fortify1636523fortify
fortis95418613fortis
forts86034453for_ts
forum108318763for_um
forums114611843forums
forward1438293forward
forwent13310533forwent
forworn13107793forworn
fought135112393fought
foully1239013foully
fourth12357443fourth_
fourthly1742523fourthly
fourths13374953fourths
fowl105723633fo_w_l
fowls115518893fo_wls
foxily1947253foxily
foxy176517753fo__xy
foy96044263fo___y
fozy197017163fo__zy
fray105428903f_r_ay
froggy1434493froggy
frosh115713403frosh_
frosty124710633frosty
froth115919283froth_
froths125411443froths
frouzy21395283frouzy
frow106425053frow__
frown115415973frow_n
frowns126011393frowns
frows116623103frow_s
frowst125512073frowst
frowsty16464983frowsty
fry96226503f_r__y
furry116719283fur_ry
fury107727973fur__y
furzy2010116063fur_zy
gorily10612503gorily
gorsy95915783gor_sy
gory86129663gor__y
growly13499173growly
growthy1773283growthy
horah117922053horah_
horahs126313873horahs
horary12310383horary
horny115619623hor_ny
horsey125115403horsey
horsy116318393hor_sy
howdy155711413ho_wdy
jowly186410903jo_wly
koruny1334443koruny
logway1335913logway
lordly1038753lordly
lorry86315673lor_ry
lory75931713lor__y
lowly114113333lo_wly
marshy14558333marshy
moray105423793mor_ay
morph121712513morph_
morpho13158443morpho
morphs13149433morphs
mothy136214553mo_thy
mouthy14409063mouthy
murphy1654343murphy
north86018273north_
norths96812323norths
noway111112843no_way
orby97519603_or_by
orgy85218003_or_gy
ortho8312293_ortho
poachy16388963poachy
porch125918623porch_
porgy116916123por_gy
porky145019333por_ky
porny106020193por_ny
portly114713403portly
pouchy16538663pouchy
roughy137010853roughy
rowdy125711533ro_wdy
sophy136611763so_phy
sorely94618013sorely
sorgho10348713sorgho
sorry84618253sor_ry
toothy12529693toothy
torah87125273torah_
torahs95115643torahs
torch107420933torch_
tory75840543tor__y
touchy145010503touchy
toughy135911073toughy
towny116114493to_wny
towy105325473to_w_y
trophy1438283trophy
why126920013___why
wordy126916163wor_dy
wormy137514253wor_my
worry116114333wor_ry
worth117120523worth_
worths127812893worths

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.376475242.0
2DLD Change Limit1127162324.82623356.0
3Display Results2322320.0802900.0
 (SQL Overall)1786912325.28233830.2
 
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.