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 “palmister” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
palmister134505(None) 
palmisters1444671palmisters
lamister1037652la_mister
palmier113312172palmi__er
palmist112814342palmist__
palmistry1642982palmistry
palmists12268812palmist_s
paymaster1643872paymaster
plaister1068012p_laister
admitter1135113_admitter
assister836743_assister
ballaster1145973ballaster
balmier113811513balmi__er
baluster1037053bal_uster
banister10199973ba_nister
bannister1155373bannister
barrister1145733barrister
blister94415313_bl_ister
canister101710853ca_nister
cannister1155723cannister
cloister1037093_cloister
demister11310223_demister
enlister847803enl_ister
filister1137403fil_ister
fillister1244423fillister
gamester1137323ga_mester
ganister9178993ga_nister
gannister1054173gannister
glister84013343_gl_ister
hamster12810423ha_m_ster
klister113410643_kl_ister
lamisters1157123la_misters
lamster9109913la_m_ster
leister73212753__leister
lister64527253__l_ister
magister1136283ma_gister
malmier113611953malmi__er
maltster1035303mal_tster
mister84728563___mister
painter93814563pa__inter
palier85023563pal_i__er
palliate10311893palliate_
palliated1238493palliated
palliates11311033palliates
palliator1146003palliator
pallier94417163palli__er
palmate113215233palm_ate_
palmated132511003palm_ated
palmer105816543palm___er
palmette1247733palmette_
palmettes1346883palmettes
palmiest123212023palmiest__
palmistries1593763palmistries
palmitate1346413palmitate_
palmitates1445453palmitates
palmitin1248053palmi_tin
palter84423263pal___ter
paster85734373pa___ster
paviser12489093pa_vis_er
paymasters1743843paymasters
permitter1345963permitter
persister1146833persister
pilaster1038163pil_aster
plaisters1137813p_laisters
plaiter93615393p_lai_ter
planisher1495853planisher
plaster93318693p_l_aster
polisher1388073pol_isher
politer92417073pol_i_ter
pollster1037103pol_lster
polyester1445353polyester
promiser122510673promis_er
psalmist1276353psalmist__
psalmists1344073psalmist_s
salimeter1157373salimeter
waister103812383wa__ister

Search took 9 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 Filter1786911486410.1731032896.0
2DLD Change Limit148641767.81319024.8
3Display Results76760.0302533.3
 (SQL Overall)178691768.01622291.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.