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

126 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
twiggen1233350(None) 
twigged13345281twigged
swigged13327182swigged
swigger12338452swigger
trigged10359852trigged
trigger9329162trigger
twiggier1333072twiggier
twigging14305672twigging
twiggy1432932twigg_y
twinge104210402twinge_
twinged12398362twinged
twinges11409452twinges
wigged124413582_wigged
bewigged1643383bewigged
bigger104315063_bigger
biggin103710603_biggin
biogen9310253_biogen
chigger1436003chigger
digged104314653_digged
digger94616083_digger
figged124013893_figged
frigged13439053frigged
gigged104112293_gigged
igged86012763__igged
jigged164412773_jigged
jigger155313053_jigger
nigger89713573_nigger
pigged114214153_pigged
piggin103111093_piggin
pigpen1136583_pigpen
prigged12398933prigged
rigged94517403_rigged
rigger85616713_rigger
smidgen11426513smidgen
snigger9328373snigger
swagged13419153swagged
swagger12389333swagger
swagmen1334973swagmen
swidden1234233swidden
swiggers13337123swiggers
swigging14337223swigging
swinge105614383swinge_
swinged123810793swinged
swinger113812563swinger
swinges113413423swinges
swingmen1443493swingmen
tagged93418123t_agged
tagger84017703t_agger
tegmen988403t_egmen
thicken16317873thicken
thighed1535273thighed
thuggee1245263thuggee
tiger65718633t_i_ger
tighten11288973t_ighten
tiglon737923t_iglon
tigon63914443t_i_gon
tinge64626623t_inge_
tinged84220803t_inged
tinges74722333t_inges
tinmen82310403t_inmen
titmen8239883t_itmen
togged95117513t_ogged
tongmen1037123tongmen
toughen11329203toughen
triage72812893triage_
triaged92810443triaged
triages82613793triages
triggers10257843triggers
triggest1036923triggest
trigging11299583trigging
trigon74513103tri_gon
trudgen9357053trudgen
tugged93813523t_ugged
tugger84013103t_ugger
twanged12387273twanged
twanger11327433twanger
tween84413743tw__een
twice104711123twi_ce_
twier84713293twi__er
twig87615773twi_g__
twiggiest1443413twiggiest
twigless1293663twigless
twigs96911173twi_g_s
twilled11398033twilled
twin76023083twi___n
twine85822363twi_ne_
twined104413123twi_ned
twiner94012593twi_ner
twines94717273twi_nes
twingeing14143393twingeing
twinging13278423twinging
twinier1037313twinier
twinjet1735113twinjet
twinned11366333twinned
twinset1039373twinset
twirled11385983twirled
twirler10285203twirler
twisted11277433twisted
twister10308953twister
twitted11326633twitted
twitter10278093twitter
tzigane1742943tzigane
wagged124616123_wagged
wagger113616013_wagger
waggon1136393_waggon
widen94717973_wi_den
widgeon1244143_widgeon
widget113815263_widget
wigan95114393_wi_gan
wigeon1037223_wigeon
wiggery15295873_wiggery
wiggier12418863_wiggier
wigging133413833_wigging
wiggle113713013_wiggle
wiggled13299603_wiggled
wiggler123110763_wiggler
wiggles123312463_wiggles
wiggly14559683_wiggly
wiggy134510733_wigg_y
wiglet105519153_wiglet
winged114620833_winged
winger104125443_winger
wingmen1336113_wingmen
wizen175813863_wi_zen
wizzen17387203_wizzen
zigged184110193_zigged

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271265.72023431.3
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.17228951.9
 
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.