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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
firry11571353(None) 
ferry116020801ferry
fiery114714791fiery
furry116719281furry
airy75734152ai_ry
berry104521772berry
birr66022362birr_
birrs74917102birrs
burry105221562burry
carry105823782carry
cirri7710722cirri
curry105920342curry
derry94721372derry
diary95016972diary
dirty95617802dirty
faery116015482faery
fairly125610012fairly
fairy115318282fairy
farcy135217092farcy
ferly115517352ferly
ferny115816182ferny
fiar76427332fiar_
fiars86720832fiars
fibre104812842fibre
fifty145211422fifty
filly114424902filly
filmy136114042filmy
finery124512892finery
finny114716752finny
fiord94313342fiord
fir66744892fi_r_
fire76245592fi_re
fired94829742fired
firer811229252firer
firers94922682firers
fires85740752fires
firm96026452fi_rm
firmly1436662firmly
firms105217422firms
firn76927502fi_rn
firns86018542firns
firs76637712fi_rs
first86226122first
firth115819532firth
fishy146011662fishy
fitly115114972fitly
fizzy199015082fizzy
flirty12499142flirty
flurry12397112flurry
foray115023972foray
forby135317672forby
forky156119642forky
forty114824272forty
fray105428902f_ray
friary124010092friary
fry96226502f__ry
fury107727972f_ury
furzy2010116062furzy
girly94415292girly
gurry94515412gurry
harry115322952harry
herry114922472herry
hurry114917182hurry
jerry155016182jerry
kerry124916092kerry
lorry86315672lorry
marry104821692marry
merry104721482merry
mirky146315522mirky
miry96326752mi_ry
murry105120232murry
parry105323752parry
perry105222712perry
serry84824122serry
sirra54416322sirra
sorry84618252sorry
tarry85422512tarry
terry84721872terry
whirry15477062whirry
wirra83210822wirra
wiry106422832wi_ry
worry116114332worry
yirr76513572yirr_
yirrs8469192yirrs

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 Filter178691538000.0931921408.6
2DLD Change Limit53800841.37639098.8
3Display Results84840.0165250.0
 (SQL Overall)178691841.485120330.6
 
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.