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

132 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
confirm143736(None) 
confirms1536301confirms
conform14310461conform
bonfire1287062bonfire
confer114018682confer_
confers124120092confers
confide13310202confide
confine12315582confine
confirmed1745562confirmed
confirmer1665662confirmer
confit113316402confi_t
confits122811422confits
conforms1538872conforms
conium10415312con_ium
infirm1137042_infirm
nonfarm1246512nonfarm
reconfirm1643812reconfirm
affirm1435523_affirm
bonfires1367383bonfires
chirm125317063c__hirm
clonism1138983clon_ism
codfish1637163codfish
coffer144112863coffer_
coffers154112693coffers
coffin14339813coffi_n
coffing163811253coffing
coffins153110193coffins
coheir1137583coheir_
coheirs1236753coheirs
coifing133213893coifing
coinfer12419393coinfer_
coinfers13349503coinfers
coir66327243co__ir_
coirs75221053co__irs
coliform1545563coliform
comfier1439163comfier
comfit133112423comfi_t
comfits14328743comfits
comfort143611693comfort
concern113011963concern
concert113325223concert
concise11314473concise
concord12510343concord
concur10411103concur_
concurs11311473concurs
condign1147733condign
condom114215363con_dom
condor94616973condor_
condors104018573condors
confab1347063conf_ab
confabs1435393confabs
confect143614273confect
conferee13613733conferee
conferva1644433conferva
confess12399903confess
confided1537453confided
confider1438123confider
confiders1537483confiders
confides14310573confides
configure1544463configure
confined14310403confined
confiner13311193confiner
confiners1439953confiners
confines13315653confines
confirmand1853223confirmand
confirmers1744963confirmers
confirming1845903confirming
confiture1445953confiture
conflict1547753conflict
conflux1943003conflux
conformal1696273conformal
conformed1767463conformed
conformer1667463conformer
confrere1347563confrere
confuse1238853confuse
confute1239263confute
conger95024273conger_
congers104223233congers
congii957363congi_i
congius103210073congius
coni65534803con_i__
conic95329793con_i_c
conics103920593con_ics
conidium1366643conidium
conies84338593con_ies
conifer123212643conifer
conifers133611703conifers
coniine9316803coniine
conin76232723con_i_n
conine84528553con_ine
coning94331823con_ing
conins84327233con_ins
coniums11311863con_iums
conjure16109073conjure
conker124721553conker_
conkers133721043conkers
conking143618453conking
conner84423963conner_
conners94023113conners
conning103718753conning
connive1238993connive
conoid9818883conoi_d
conoids10813883conoids
consign1038773consign
consist9316033consist
consort91319903consort
conspire1257873conspire
contort91422343contort
contra83314703con_tra
convert123721473convert
convict143410983convict
corium10315723co_rium
corm85735383co___rm
cosmism1337013cosmism
cowbird1534433cowbird
cowfish1836433cowfish
cowgirl1353273cowgirl
cronyism1544723cronyism
cuniform1555023cuniform
disconfirm1853153disconfirm
eonism83213533eon_ism
firm96026453___firm
foxfire2042563foxfire
gonium949803gon_ium
gunfire1134743gunfire
infirms1245563_infirms
inform11310153_inform
ionium8610923ion_ium
monism104016313mon_ism
onium73115533_on_ium
reconfirms1743133reconfirms
tonearm937443tonearm

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271326.17321711.8
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.64226903.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.