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

144 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
polarise1051390(None) 
polarised1269231polarised
polarises11514071polarises
polarize19512651polarize
solarise8512541solarise
polarity131310402polarity
polarized21610282polarized
polarizer2079172polarizer
polarizes20513022polarizes
polars84419352polar_s_
popularise1445422popularise
solarised1068042solarised
solarises9512702solarises
solarism10810382solarism
solarize17511472solarize
apologise1248303apologise
arise56436433___arise
bipolarize2353743bipolarize
boarish123911913bo_arish
botanise1039643botanise
boyarism1546393boyarism
claries93422203_claries
coarse84813903co_ar_se
colonise102514283colonise
colorism122112433colorism
colorist102818993colorist
colorize192314203colorize
comprise14310813comprise
covaries13413253covaries
depolarize2246483depolarize
dolerite9611773dolerite
dollarize1946193dollarize
filariae1148463filariae
focalise131210373focalise
hoarse94411323ho_ar_se
holards1148433holards_
larine63927043__larine
laris54737463__laris_
localise101511853localise
malaise9312673mala_ise
molarity13118903molarity
molars85517323molar_s_
moonrise1046783moonrise
moralise10314913moralise
motorise10311523motorise
notaries8314933notaries
notarize1749293notarize
ovaries10312653_ovaries
paganise1139663paganise
paise75028333p__a_ise
palais8420423pala_is_
palatine10316063palatine
palewise1346423palewise
paradise112113873paradise
paries84742513p__aries
paris75145943p__aris_
parises94827183p__arises
parish115022353p__arish
parse75236993p__ar_se
parvise124211693p__arvise
pavise114714803p__avise
pedlaries12108783pedlaries
pelerine10313013pelerine
peltries10313023peltries
penalise101013763penalise
pharisee1347603p_harisee
plaice10311553p_la_ice
planish12412053p_lanish
platies93722543p_laties
poetise9314043po_etise
poetries10315583poetries
poise75127893po___ise
polar75623453polar___
polariscope17122273polariscope
polarising1347663polarising
polarities121211773polarities
polarizers2165893polarizers
polaron939843polar_on
polarons1039863polarons
poleis86018353pol_eis_
polemist12412363polemist
polemize2148673polemize
polers84225643poler_s_
police102918563pol__ice
policies122415663policies
polies84034583pol__ies
polis74731163pol__is_
polish114916723pol__ish
polite83625073pol__ite
polities102722343polities
pollards11299523pollards_
pollist9816603pol_list
poloist91016323pol_oist
polonaise1145853polonaise
polyamide1745583polyamide
polyamine1647203polyamine
polymerise1766683polymerise
polyparies1747833polyparies
polypide1647013polypide
pooris83916843po_oris_
poorish123712303po_orish
poperies12316793poperies
poplars113910333poplar_s_
popularised1653783popularised
popularises1555153popularises
popularize2345683popularize
porism104518063po__rism
porose84818743po__rose
porpoise1248083porpoise
poularde11276573poular_de
poulardes12286183poulardes
poulards11288233poulards_
poultries1148453poultries
praise84419413p_ra_ise
prise74632613p___rise
prolamine131510563prolamine
prolapse12134913prola_pse
pulverise1445063pulverise
repolarize2146183repolarize
rolamite1048743rolamite
romanise10312133romanise
rosaries8312783rosaries
rotaries8315693rotaries
salaries8319573salaries
solanine8311533solanine
solaria7312493solari_a
solarisms1168813solarisms
solarium1078263solarium
solarized1969153solarized
solarizes18511613solarizes
solecise1089073solecise
souaris7312333souaris_
tolars64817943tolar_s_
totalise8312503totalise
tovarish1445123tovarish
valorise112110303valorise
velarize2048763velarize
vocalise131510813vocalise
volatile1146433volatile
voleries11313233voleries
votaries11312013votaries
votarist111012163votarist
vulgarise13495993vulgarise
womanise1348733womanise

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621448.19017846.4
3Display Results1441440.0602400.0
 (SQL Overall)1786911448.40621257.6
 
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.