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

135 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
pachisi1432952(None) 
pachisis15268821pachisis
parchisi15368931parchisi
pachas135017142pachas_
parchesi15358212parchesi
parchisis16318572parchisis
rachis114017652rachis_
tachism1478872tachism
tachist12613292tachist
aches106132293_aches_
achier113914263_achier
achiest12315183_achiest
aching126521973_aching
acini75718983_ac_ini
ahis76135383_a_his_
apaches143411833apaches_
aphis105917133_aphis_
bacchii1644533bacchi_i
baches135426943baches_
baching156017753baching
caches137926913caches_
caching156317503caching
chili106218483__chili
chis95933313__chis_
dachas124113253dachas_
dashiki1544203dashiki
dashis104414393dashis_
echini114710433_echini
hashish1238353hashish
kachina1637663kachina
laches116528343laches_
lathis95516173lathis_
lichis115212593lichis_
maches134827233maches_
machine14313493machine
machismo1754203machismo
machoism1746393machoism
machos135217493machos_
machs125722563mach_s_
marchesi15337323marchesi
nachas114914193nachas_
naches114622413naches_
nachos115014183nachos_
orchis11710773orchis_
pacas96029403pac_as_
pacers105124543pacers_
paces96741113pac_es_
pacha126518063pach__a
pachalic1757273pachalic
pachinko1942303pachinko
pachouli1553623pachouli
pachuco1642903pachuco
pacier105018683pac_ier
paciest112917803paciest
pacific1646913pac_ific
pacifism1746373pacifism
pacifist1548093pacifist
pacify1667473pac_ify
pacing114522753pac_ing
packing164420723packing
packs135528933pac_ks_
pacs85842183pac__s_
paction112713963paction
pacts95125803pac_ts_
padis86227143pa_dis_
paisa76021073pa__isa
paise75028333pa__ise
palais8420423palais_
palish114718273pa_lish
palmist112814343palmist
panfish15229973panfish
panini8314273pa_nini
paphian1437453paphian
papism122211513pa_pism
papist102618743pa_pist
parcheesi16233763parcheesi
parches143720003parches_
parchesis16318213parchesis
parching164313053parching
paris75145943pa_ris_
parish115022353pa_rish
parvis116114803parvis_
parvise124211693parvise
pashas115117063pashas_
pashes115828393pashes_
pashing135120513pashing
pastis84924323pastis_
patches143320383patches_
patchier15319663patchier
patchiest1638353patchiest
patchily1885813patchily
patching163212753patching
pathos115516693pathos_
paths105521383path_s_
patois84319363patois_
pavis106422733pa_vis_
pavise114714803pa_vise
peaches144120053peaches_
peachier1548623peachier
peachiest1638523peachiest
peaching163613643peaching
peching154513903peching
pechs125516203pech_s_
peckish18227293peckish
phis95724903p__his_
phthisic1853903phthisic
phthisis1654443phthisis
poaches144416943poaches_
poachier1556823poachier
poachiest1636883poachiest
poaching163510833poaching
practise12310143practise
puckish18237213puckish
rachial122012173rachial
rachises131412413rachises
rachitic1547593rachitic
rachitis1348353rachitis
racism103214193rac_ism
racist82822793rac_ist
raphis114014323raphis_
rhachis1555693rhachis_
sacrist9315423sacrist
sashimi1244643sashimi
schism1338173_schism
schist11312653_schist
spahis11310383spa_his_
taches114224173taches_
tachinid1446243tachinid
tachisme1554693tachisme
tachisms1567143tachisms
tachiste1356213tachiste
tachists1348183tachists
tachs105820933tach_s_
tahini939893ta_hini
yachts1437023yachts_

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271357.12618808.2
3Display Results1351350.0931451.6
 (SQL Overall)1786911357.60923484.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.