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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

94 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
tip56551231tip_
tipi69924441tipi
tips66436771tips
dip67848992dip_
dips75536922dips
dipt77339332dipt
gip67645372gip_
gips75632932gips
hip86750442hip_
hips96433712hips
kip97042152kip_
kips106430532kips
lip514755812lip_
lipa68425932lipa
lipe66839742lipe
lips67141452lips
mips85534092mips
nip56945992nip_
nipa69421642nipa
nips65830932nips
pip78051052pip_
pipe86434442pipe
pips85837142pips
pipy115421522pipy
rip56851312rip_
ripe66038932ripe
rips66237442rips
sip57656022sip_
sipe67341052sipe
sips65740112sips
stipe76523372stipe
taj106442192t_aj
tap57663882tap_
tapa65129152tapa
tape64538152tape
taps66050682taps
tepa66021682tepa
ti28448302ti__
tic56343472ti_c
tick106231232tick
tics65729642tics
tide55237392tide
tidy86822432tidy
tie36557542ti_e
tied55535222tied
tier44936152tier
ties45248322ties
tiff104727732tiff
tike85534492tike
tiki87620852tiki
til36350272ti_l
tile45451452tile
till45941212till
tils45739622tils
tilt46252432tilt
time66235022time
tin36362182ti_n
tine45855142tine
ting56139922ting
tins45251312tins
tint46758872tint
tiny76134642tiny
tipis76019922tipis
tippy125411792tippy
tipsy106010502tipsy
tire46143362tire
tirl45029932tirl
tiro46832372tiro
tis37056652ti_s
tit36771062ti_t
titi47130632titi
tits46145052tits
tivy1014516872tivy
top510560682top_
tope65946382tope
toph96326872toph
topi67830392topi
topo66932402topo
tops66248122tops
trip66830392trip_
tripe75425382tripe
trips74923362trips
tup56037542tup_
tups65628762tups
type96223742type
typo95418122typo
typp115812782typp
typy126013042typy
wipe94830292wipe
yip87241192yip_
yipe96722192yipe
yips95226712yips
zip146636232zip_
zips155723802zips

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit29872940.89033564.0
3Display Results94940.0165875.0
 (SQL Overall)178691941.186150666.9
 
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.