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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
pottier9351649(None) 
cottier93814171cottier
dottier83910921dottier
pettier94213611pettier
plottier10327261plottier
potter83926981pott_er
potties93723541potties
poutier93215321poutier
puttier93314501puttier
spottier10207311spottier
battier93515712battier
bittier94211662bittier
blottier10336412blottier
bottler94211882bottler
cattier93317072cattier
cotter84926672cott_er
cottiers10399152cottiers
dotier73917032do_tier
dotter74419342dott_er
fattier103513462fattier
footier104115112footier
goutier82612352goutier
grottier9316672grottier
guttier83911102guttier
hootier104915352hootier
hotter94720082hott_er
hottie92514382hottie_
hotties103016962hotties
jettier14358692jettier
joltier14318492joltier
jotter134315632jott_er
knottier12203982knottier
loftier1037762loftier
lotter64025602lott_er
mothier121910212mothier
motlier92010582motlier
mottler94410342mottler
nattier73614622nattier
nettier74211812nettier
nittier73512242nittier
nuttier73112022nuttier
otter54423972_ott_er
partier93520712partier
pastier94320382pastier
patter84628262patt_er
pattie84020962pattie_
patties93425142patties
peatier94017232peatier
pestier94317402pestier
petter83924772pett_er
pithier123010292pithier
pitier84019822p_itier
platier93716292platier
plotter94113662plott_er
plotties103111412plotties
pockier153911602pockier
podgier11338722podgier
poetiser1037312poetiser
poetizer1936812poetizer
pointier1038302pointier
pokier124914632po_kier
politer92417072politer
porkier133712342porkier
pornier93413132pornier
porter84224412port_er
portiere1038772portiere
portlier1038372portlier
poster84129172post_er
postie84123962postie_
posties93128812posties
pother113818852po_ther
potpie103412432potpie_
potpies113116172potpies
potsie83916032potsie_
potsies93019482potsies
potted94624012pott_ed
potteen9319672potteen
potterer102310262potterer
potters94024342pott_ers
pottery123011072pott_ery
pottiest102815972pottiest
potting103720892potting
pottle84416102pottle_
pottles93816982pottles
potzer174411212po_tzer
pouter83923982pout_er
powter114116032powt_er
poxier153812112po_xier
prettier1069042prettier
purtier93214092purtier
putter83921442putt_er
puttie84116302puttie_
puttied103811162puttied
puttiers10288012puttiers
putties94420022putties
rattier74015592rattier
rootier74915392rootier
rotter64325462rott_er
ruttier73412282ruttier
snottier8217382snottier
sootier73916612sootier
sportier102010052sportier
spotter94514882spott_er
tattier74216242tattier
totter65021462tott_er
wittier103910822wittier
zootier163611172zootier

Search took 5 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 Filter1786911076710.750238254.7
2DLD Change Limit1076711073.61029825.8
3Display Results1071070.0462326.1
 (SQL Overall)1786911074.40640556.3
 
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.