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

101 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
fiery11471479(None) 
faery116015481faery
finery124512891finery
firry115713531firry
aery77231682_aery
airy75734152ai_ry
apery106517902apery
beery105220122beery
bier65531832bier_
biers76225222biers
briery114510772briery
diary95016972diary
eery76129622_eery
emery104814332emery
every115215452every
fairy115318282fairy
fakery16509262fakery
fer66646122f_er_
fere76342232f_ere
ferly115517352f_erly
fern76129322f_ern
ferny115816182f_erny
ferry116020802ferry
fey95940882f_e_y
fiar76427332fiar_
fiars86720832fiars
fiber104921132fiber_
fibers114717522fibers
fibre104812842fibre
fie67152442fie__
fief107331362fie_f
fiefs116213702fiefs
field95015322field
fiend95312982fiend
fierce11348912fierce
fierily1339022fierily
fifer115519972fifer_
fifers125414922fifers
fifty145211422fifty
filer85433002filer_
filers94623722filers
filly114424902filly
filmy136114042filmy
finely123011562finely
finer85431562finer_
finny114716752finny
fiord94313342fiord
fir66744892fi_r_
fire76245592fi_re
fired94829742fired
firer811229252firer
firers94922682firers
fires85740752fires
firm96026452fi_rm
firn76927502fi_rn
firs76637712fi_rs
fishery16397732fishery
fishy146011662fishy
fitly115114972fitly
fiver116024942fiver_
fivers124420922fivers
fixer154717832fixer_
fixers165112982fixers
fizzy199015082fizzy
fleury12417352fleury
fley106626852fle_y
flier86023402flier_
fliers94417192fliers
frere85617722frere
friary124010092friary
frier85225842frier_
friers94718932friers
fry96226502f__ry
furry116719282furry
fury107727972f_ury
kier86526812kier_
kiers95320092kiers
leery85919132leery
lier45942462lier_
liers55130402liers
livery124910902livery
miry96326752mi_ry
misery114113542misery
nitery94412172nitery
onery8414122onery
peery105719442peery
pier66035292pier_
piers75926332piers
piety105817302piety
pinery115214292pinery
query174212082query
tier44936142tier_
tiers55526522tiers
veery115816252veery
very108025642_very
vier75428152vier_
viers85621952viers
viewy14518102viewy
vinery124912602vinery
winery125014282winery
wiry106422832wi_ry

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.330541487.9
2DLD Change Limit538001011.65632487.9
3Display Results1011010.0137769.2
 (SQL Overall)1786911011.99989390.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.