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

146 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
forty11482427(None) 
borty105522831borty
dorty96220811dorty
footy115820531footy
foray115023971foray
forby135317671forby
forky156119641forky
fort76456441fort_
forte86131461forte
forth116222671forth
forts86034451forts
aorta55922572aorta
arty77531312_arty
booty106125912booty
bort65960962bort_
borts76735452borts
bortz165722202bortz
corby125018532corby
corky145221152corky
corny106023272corny
cory96941512cor_y
dirty95617802dirty
dorky135518742dorky
dormy115817472dormy
dory85836232dor_y
dotty94516102dotty
doty86128222do_ty
farcy135217092farcy
fart76860562fart_
farts88336842farts
fatty115117412fatty
ferity122813342ferity
ferly115517352ferly
ferny115816182ferny
ferry116020802ferry
fifty145211422fifty
firry115713532firry
firth115819532firth
flirty12499142flirty
floaty124210942floaty
fluty114415642fluty
foamy135313202foamy
fogey125617872fogey
foggy136714542foggy
fogy115923182fo_gy
foley115222302foley
folky159214712folky
folly115022602folly
font77143752font_
fonts86124752fonts
foot76248012foot_
foots85528282foots
footsy12587932footsy
for66952072for__
fora75937392for_a
foram105124932foram
forays124813002forays
forb97131332for_b
forbs105720802forbs
forbye14427882forbye
force105324272force
ford86835492for_d
fordo97218652fordo
fords95328182fords
fore78351472for_e
foreby1438632foreby
fores85847102fores
forge95126942forge
forgo94418332forgo
fork115930942for_k
forks125324682forks
form95836872for_m
forme105225992forme
forms105327052forms
formyl14276442formyl
fortes95327182fortes
fortify1636522fortify
fortis95418612fortis
forum108318762forum
forwhy1834422forwhy
fourth12357442fourth
foxy176517752fo_xy
foy96044262fo__y
fozy197017162fo_zy
fray105428902f_ray
frosty124710632frosty
froth115919282froth
frothy15578372frothy
fry96226502f_r_y
furry116719282furry
fury107727972fur_y
furzy2010116062furzy
fusty115016522fusty
gorsy95915782gorsy
gory86129662gor_y
gouty95217362gouty
hooty115022442hooty
horny115619622horny
horsy116318392horsy
jolty155713032jolty
jotty155012602jotty
lofty115813302lofty
lorry86315672lorry
lory75931712lor_y
moray105423792moray
mort66758832mort_
morts75533562morts
north86018272north
orby97519602_orby
orgy85218002_orgy
ort39465232_ort_
orts46538332_orts
party106630612party
porgy116916122porgy
porky145019332porky
porny106020192porny
port66059632port_
portly114713402portly
ports75934592ports
potty105621002potty
pouty107018812pouty
purty105019402purty
rooty86423022rooty
shorty124313202shorty
softy115414482softy
sooty84924842sooty
sorry84618252sorry
sort46264812sort_
sorta57125412sorta
sorts54536662sorts
sporty115112492sporty
tarty86328182tarty
tort46967462tort_
torta55925352torta
torte55431702torte
torts56138122torts
tory75840542tor_y
warty119323822warty
wordy126916162wordy
wormy137514252wormy
worry116114332worry
wort76654752wort_
worth117120522worth
worthy15598802worthy
worts88631182worts
zooty175415352zooty

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit538001461.70331591.3
3Display Results1461460.0334424.2
 (SQL Overall)1786911462.04687336.8
 
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.