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

90 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
kipperer1629472(None) 
kippered17255621kippered
kipperers17233821kipperers
cipherer1545572cipherer
dapperer1335762dapperer
kipper143414212kipp__er
kippers153211432kipper_s
lippered13287952lippered
pepperer1145282pepperer
simperer1237172simperer
skippered1843432skippered
zippered22244822zippered
bickerer16106773bickerer
bitterer10309773bitterer
caperer113013403_caperer
chippered1945003chippered
ciphered1637053ciphered
cipherers1644893cipherers
coppered153410543coppered
diapered1238003diapered
diplexer1844213diplexer
dipper114017793dipp__er
dippers123615183dipper_s
dippier123111393dipp_ier
disperser12109083disperser
ditherer12187763ditherer
filterer11258143filterer
fingerer12127223fingerer
gipper114215303gipp__er
gippers123212083gipper_s
hamperer15379093hamperer
hinderer1238273hinderer
hipper133818023hipp__er
hippier143212103hipp_ier
impeder12438533_impeder
impurer1136483_impurer
kipped153114573kipp__ed
kippen14299013kipp__en
kippering18205443kippering
lappered13288213lappered
limberer12187053limberer
lingerer9118303lingerer
lippened13255223lippened
lipper104219633lipp__er
lippers113416443lipper_s
lippier112710573lipp_ier
litterer82810173litterer
loppered13326753loppered
miterer92511333mi_terer
nipper103715713nipp__er
nippers113012623nipper_s
nippier11319833nipp_ier
pamperer14228333pamperer
paperer113111903_paperer
peppered1236133peppered
pepperers1244903pepperers
pilferer1344923pilferer
properer1259203properer
ripener937903ri_pener
ripper103518653ripp__er
rippers114115033ripper_s
rippler113210103ripp_ler
ripplier1234463ripplier
silverer11216733silverer
simpered1338253simpered
simperers1335933simperers
sincerer1037203sincerer
sipper103920993sipp__er
sippers113117753sipper_s
skipper15339573skipp__er
skippers16318203skipper_s
slippered1434823slippered
slipperier1442703slipperier
tamperer12248893tamperer
taperer92511793_taperer
temperer12227723temperer
tinkerer1286803tinkerer
tipper103918413tipp__er
tippers113414353tipper_s
tippier113210543tipp_ier
tippler11348343tipp_ler
titterer8268523titterer
whimperer19123723whimperer
whisperer17133693whisperer
winterer112110443winterer
witherer14187953witherer
yippee132810743yippe_e_
zipper193813123zipp__er
zippers203310383zipper_s
zippier20308193zipp_ier

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 Filter1786911461620.423422437.4
2DLD Change Limit146162906.57622226.6
3Display Results90900.0332727.3
 (SQL Overall)178691907.03225411.1
 
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.