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

147 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
position1091219(None) 
positions11811501positions
positron1096901positron
apposition1446592apposition
coition9314312co_ition
deposition13107832deposition
exposition1947162exposition
imposition1446532imposition
monition10311722monition
opposition1445482opposition
petition10711752petition
portion9615492po_rtion
positing11312302positing
positional1247902positional
positioned1396002positioned
positive1349992positive
positrons1186542positrons
postilion11117462postilion
postin83521032pos_ti_n
potation101716782potation
potion84519572po__tion
punition1038372punition
reposition121010142reposition
volition1179172volition
abolition1147053abolition
addition1096893addition
ambition1246563ambition
appositions1546153appositions
audition979173audition
bastion9312473bas_tion
boston8513043bos_t_on
coaction12310773coaction
coalition1148703coalition
cognition1247013cognition
coitions10312853co_itions
composition1746793composition
conation101420883conation
condition12411163condition
cooption1288343cooption
depositions14117683depositions
disposition1446693disposition
dominion11147033dominion
donation91513783donation
dotation91412733dotation
edition8310853_edition
expositions2046843expositions
foliation121110793foliation
fruition11106103fruition
ignition946533ignition
impositions1546033impositions
iodation9310383iodation
lenition8310083lenition
lobation102110553lobation
location102113913location
locution10227663locution
lotion65716523lo__tion
malposition1553963malposition
misposition1555683misposition
monitions11310883monitions
motion85217553mo__tion
munition1038763munition
notation81414603notation
notion64516583no__tion
novation111710013novation
opinion946793_opinion
oppositions1575123oppositions
option83612713_o_ption
oration71617713_oration
ovation101510023_ovation
oviposition1653593oviposition
paction112713963p_action
partition1148693partition
passion9310883pas_sion
pavilion1344913pavilion
perdition1249013perdition
petitions11511083petitions
phonation1439393phonation
pinion83815893p__inion
piosities11311723piosities
piston83515923pis_t_on
piton76121583p__it_on
plosion939113plos__ion
poditic122611583poditi_c
poison8312223po_i_son
politic112918713politi_c
politick16289333politick
politico122510013politico
politicos13287083politicos
politics122513813politics
polities102722343polities
pollution1146003pollution
ponton83217643po_nt_on
pontoon93010703po_ntoon
portions10514413po_rtions
posit75833333posit___
posited10511493posit_ed
positioning1454553positioning
positiver1445483positiver
positives1459173positives
posits85718713posit__s
postbox1885493pos_tbox
postboy1476673pos_tboy
postdoc1245263pos_tdoc
posteen93512623pos_teen
postern93615613pos_tern
postie84123963pos_ti_e
posties93128813pos_ties
postilions12116283postilions
postillion1255653postillion
posting105622243pos_ting
postins93721203pos_tins
postman112410043pos_tman
postmen113110423pos_tmen
postop10511943pos_t_op
postpone1248693pos_tpone
postriot10412253postriot
postteen1055693postteen
potations111615073potations
potions93417423po__tions
preposition15108583preposition
proaction13410103proaction
probation13412183probation
promotion1359503promotion
pronation11415703pronation
proposition1588743proposition
proration11415983proration
prosimian1366003prosimian
provision1447633provision
pulsation1137143pulsation
punitions1137923punitions
pupation1269503pupation
repositions131110163repositions
rogation91612053rogation
rotation81615453rotation
sedition939333sedition
solation8916153solation
soliton7410233solit_on
solution889593solution
sorption1037513sorption
sortition946703sortition
spoliation1248423spoliation
supposition1555203supposition
tuition738823_tuition
vocation132311983vocation
volitions1288663volitions
volution1198603volution
zonation171410723zonation

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621477.03320782.3
3Display Results1471470.0602450.0
 (SQL Overall)1786911477.51323784.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.