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

160 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
firms10521742(None) 
farms106324951farms
films105617961films
fires85740751fires
firm96026451firm_
firns86018541firns
firs76637711fir_s
forms105327051forms
affirms1534382affirms
aims67738182ai_ms
airns55521032airns
airs46447422air_s
airts55626342airts
arms66137492_arms
barms96128462barms
berms95323662berms
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
brims94721622brims
chirms135113982chirms
cires74932912cires
corms95626222corms
derms85022892derms
dims75435022di_ms
dirams94413702dirams
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
dorms85723842dorms
fairs85825442fair_s
fards96629842fards
fares85852872fares
farls85731112farls
farm95934532farm_
faros85532022faros
farts88336842farts
fems96428702f_ems
feres86038182feres
fermi103914162fermi
fermis114313502fermis
ferns85220082ferns
fiars86720832fiars
fiats85324482fiats
fibres114312122fibres
fibs96329502fi_bs
fices106031162fices
ficus105015492ficus
fidos95819052fidos
fids87034742fi_ds
fiefs116213702fiefs
fifes114822392fifes
figs85332642fi_gs
files85441272files
fills84632372fills
film94828172film_
filmi105914002filmi
filmis114610282filmis
filmy136114042filmy
filos86125382filos
fils75838692fi_ls
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fi_ns
fiords10498622fiords
fir66744892fir__
fire76245592fir_e
fired94829742fired
firer811229252firer
firers94922682firers
firman112211342firman
firmans12238522firmans
firmed125411882firmed
firmer114712442firmer
firmers124711442firmers
firmest1239272firmest
firmly1436662firmly
firn76927502fir_n
firry115713532firry
first86226122first
firsts95110922firsts
firth115819532firth
firths125113502firths
fiscs105311882fiscs
fists85527542fists
fits76043462fi_ts
fives116027362fives
fixes154723592fixes
flams105125012flams
flirs85518932flir_s
flirts95411482flirts
foams105017952foams
forams115115912forams
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
form95836872form_
forme105225992forme
formes114623712formes
forts86034452forts
forums114611842forums
fries85535602fries
frigs96019272frigs
frits86129102frits
furls85322052furls
furs76735042fur_s
germs85118872germs
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
gorms85619592gorms
harms106829012harms
herms105626432herms
hims95230972hi_ms
hires86134342hires
infirms1245562infirms
ires45639282_ires
iris45732552_iris
irks86220132_irks
isms66213472_isms
jisms14458002jisms
kirks84915262kirks
kirns95315452kirns
kirs85831742kir_s
liras56021982liras
mires75640882mires
mirks115122142mirks
mirs66940572mir_s
nims66226882ni_ms
norms76019312norms
perms95524512perms
pirns76020092pirns
prims95425932prims
rims65936302ri_ms
sims65737172si_ms
sires55945372sires
sirs44338332sir_s
terms75523472terms
tires55437492tires
tirls54519802tirls
tiros54524892tiros
trims75021472trims
vims95423312vi_ms
vires84529682vires
virls85618602virls
virus85316842virus
warms107726852warms
wires86034912wires
worms105320762worms
yirds96612512yirds
yirrs8469192yirrs
zirams17438642zirams

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.626285448.9
2DLD Change Limit538001602.22024234.2
3Display Results1601600.0463478.3
 (SQL Overall)1786911602.89261788.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.