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

104 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
partisan105842(None) 
artisan759461_artisan
bartisan1056161bartisan
partisans1167491partisans
partizan1955651partizan
artisans888522_artisans
bartisans1165552bartisans
bartizan1954412bartizan
bipartisan1452042bipartisan
martian93514682marti_an
paisan84417072pa__isan
parian83223962par_i_an
parmesan1244752parmesan
partan83820562part__an
partial92616262parti_al
partisanly1543462partisanly
partita9310862partita_
partitas10310262partitas
partizans2055252partizans
ptisan8417972p__tisan
antiman9313883_antiman
antisag838043_antisag
arisen65316793_ar_isen
artisanal983823_artisanal
artist64125543_artis_t
artiste73813693_artiste
artists74215593_artists
barbican1445343barbican
bartizans2053703bartizans
cardigan1245623cardigan
earthman1346473earthman
garrison943983garrison
harijan1735783har_ijan
harridan12145123harridan
larrigan944213larrigan
martial92415413marti_al
martians103111613marti_ans
martin84122523marti__n
marzipan2142693marzipan
nonpartisan1353003nonpartisan
paction112713963pacti_on
paesan85114093pa__esan
paisa76021073pa__isa_
paisana94010223pa__isana
paisano9429513pa__isano
paisans93614753pa__isans
paisas84317493pa__isas
paphian1437453paphi_an
paradisal1246883paradisal
parasang1147333par_asang
parazoan1946553parazoan
pareira937543pareira_
pareiras1038193pareiras
pariah114320583par_i_ah
parians93519743par_i_ans
paris75145943par_is__
parises94827193par_ises
parish115022363par_is_h
parmesans1344103parmesans
parson83817903par__son
partaken1445553partaken
partans94418283part__ans
partials101911973partials
partible1238073partible
particle1239543particle
partied103516553parti_ed
partier93520713parti_er
partiers103514253partiers
parties93230873parti_es
parting103527383parti_ng
partings113513743partings
partite9317133parti_te
partition1148693partition
parton84720993part__on
parts77743373part_s__
partway1535923part_way
parvis116114803parvis__
parvise124211693parvis_e
parvises133911923parvises
pastina93914593pastina_
pastinas103712163pastinas
pastis84924323pastis__
pastises103616053pastises
patin76832853pa_ti__n
patina86022193pa_tina_
patinae95414403pa_tinae
patinas96318533pa_tinas
patrician1367483patrician
pattypan1541863pattypan
pentosan1045733pentosan
permian112612283permi_an
portion9615493porti_on
prison8514023p_r_ison
protistan1145983protistan
ptarmigan1442053ptarmigan
ptisans9317363p__tisans
puritan939283pur_itan
spartan948333spart__an
spartina1037983spartina_
spartinas1135803spartinas
tartan64217513tart__an
tartish101512633tartis_h
tertian7511193terti_an
warison1037083war_ison

Search took 10 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 Limit1461621048.94016349.2
3Display Results1041040.0462260.9
 (SQL Overall)1786911049.40618997.6
 
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.