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

177 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
twin7602308(None) 
tain45548071tain
thin76732381thin
tin36362171t_in
twain86313621twain
twig87615771twig
twine85822361twine
twins85118981twins
twiny116012811twiny
twit76329061twit
tyin76424001tyin
win66456291_win
agin56132712agin
ain37579092_ain
akin86328032akin
amin66042242amin
atwain937812atwain
awing96827322awing
awn68035912aw_n
ayin76331742ayin
bin56658632_bin
blin67228172blin
brin67038192brin
cain65643912cain
chin96934742chin
coin66645352coin
din46459462_din
djin12911632djin
dwine95616142dwine
fain75840562fain
fin66458032_fin
foin77231562foin
gain56042162gain
gin46055752_gin
grin55733722grin
gwine95513662gwine
hin67559562_hin
hwan105716892hwan
in28150862__in
iwis77117002iwis
jin106443932_jin
join116724832join
kain85334292kain
kin76353962_kin
lain46146282lain
lin37967372_lin
loin46838722loin
main65345502main
owing96222722owing
own66429702ow_n
pain65647242pain
pein65834942pein
pin57066722_pin
pyin96823232pyin
quin135823922quin
rain46251732rain
rawin85521472rawin
rein46040892rein
rewin85623962rewin
rin36663182_rin
ruin47430512ruin
sain45551292sain
shin75634302shin
sin36265892_sin
skin85927522skin
spin66231302spin
stain55727932stain
stein54620532stein
swain84919052swain
swan76631312swan
swig85818022swig
swim96221392swim
swine85625302swine
swing96124842swing
swink125116352swink
tail45443652tail
tains54936322tains
taint55542282taint
takin94921302takin
tan37167562t_an
tarn46842722tarn
tawie84819812tawie
tawing104521552tawing
teen45938202teen
teind6213612teind
ten35856112t_en
tern46134802tern
tewing103914822tewing
than76128772than
thein85919022thein
then78429692then
thine85026852thine
thing96622962thing
think125018792think
thins85826322thins
thio77225412thio
thir76420542thir
this76027382this
ti28448292t_i_
tic56343462t_ic
tie36557532t_ie
til36350262t_il
tine45855132t_ine
ting56139892t_ing
tins45251302t_ins
tint46758862t_int
tiny76134632t_iny
tip56551222t_ip
tis37056642t_is
tit36771042t_it
toil46536282toil
toit46353062toit
ton310265102t_on
toon47740632toon
torn46044252torn
towie85821872towie
towing103823192towing
town76928702town
toxin124716712toxin
train56529112train
trig55528162trig
trim65329512trim
trine54734602trine
trio45233342trio
trip66830392trip
tui37034022tui_
tuis44829642tuis
tun35845192t_un
turn46330382turn
twa67721642tw_a
twae74719572twae
twains95811182twains
twang94511852twang
twas76824082twas
twat75831512twat
twee76827082twee
tween84413742tween
twice104711122twice
twier84713292twier
twigs96911172twigs
twill85612722twill
twined104413122twined
twiner94012592twiner
twines94717272twines
twinge104210392twinge
twirl85011942twirl
twirp10468942twirp
twist86820982twist
twits86015792twits
twixt155512482twixt
two67925832tw_o
twos76718022twos
tying96019832tying
tyiyn11635332tyiyn
vain75233002vain
vein75625752vein
wain75840192wain
wan66761932_wan
wen66249602_wen
whin105225692whin
wig76740382_wig
wind85533852_wind
wine74953422_wine
wing86339222_wing
wink116435022_wink
wino75933612_wino
wins75949172_wins
winy107034322_winy
wis66552332_wis
wit66563772_wit
wiz156434152_wiz
won66252062_won
wyn95921442_wyn
yin67648732_yin
ywis105313102ywis
zein135620602zein
zin125643772_zin

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.1401276364.3
2DLD Change Limit298721771.00029872.0
3Display Results1771770.0802212.5
 (SQL Overall)1786911771.220146468.0
 
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.