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

116 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
wantoners1211667(None) 
wantoner1187561wantoner_
atoners75013952_a_toners
intoners889932_intoners
waggoners1443182waggoners
wagoners1235472wa_goners
wanters104420092want__ers
wantoned12117222wantone_d
wantonness1342842wantonness
wantons103713012wanton__s
abandoners1342473abandoners
actioners1147723_actioners
almoners1068133_almoners
ancones93116343_ancone_s
annoyers1185033_annoyers
anthers103715203_ant_hers
antlers74014743_ant_lers
antonyms1345873_antonyms
atoner64817193_a_toner_
atones65225773_a_tone_s
banners94018713ban__ners
banterers112410003banterers
banters94623113bant__ers
batteners11238163batteners
buttoners1145703buttoners
canners93822663can__ners
cannoneers1243323cannoneers
canoers94318373can_o_ers
canoness1039393can_oness
canters94827733cant__ers
cantoned111411523cantone_d
cantons95221203canton__s
cantors94620753canto__rs
canyoneers1542943canyoneers
canzones1939153canzone_s
canzonets2044483canzonets
cautioners1244713cautioners
centners1057243cent_ners
centones10313663centone_s
condoners122811513condoners
falconers1445323falconers
fanners103914653fan__ners
fasteners12237053fasteners
fatteners12236873fatteners
gammoners1444563gammoners
handovers16136183handovers
hangovers16144163hangovers
hasteners12267813hasteners
intoner7811673_intoner_
intones7816543_intone_s
jawboners21133053jawboners
lactones10311223lactone_s
landowners1443483landowners
lanners73618333lan__ners
mangonels1294373mangonels
manners93417833man__ners
manpowers1644463manpowers
mentioners1245343mentioners
panners93621273pan__ners
panthers13510783pant_hers
pardoners12208213pardoners
partners102711133part_ners
pontoniers1245323pontoniers
ransomers1146873ransomers
ranters73323643rant__ers
ratooners965833ratooners
ratteners9237263ratteners
santonins948453santonins
santoors837633santo_ors
santours837183santo_urs
stoners74817953__stoners
tanners74018393tan__ners
tattooers943633tattooers
tautomers1144213tautomers
tenoners858713ten_oners
toners64128003___toners
vanners103612843van__ners
vintners1134573vint_ners
wafters134112813waft__ers
waggoner1343423waggoner_
wagoner1136093wa_goner_
waiters104218623wait__ers
wakeners1535843wa_keners
walkovers1942613walkovers
wallopers14136273wallopers
wallowers15127653wallowers
waltzers2034003walt_zers
wanderers13228483wanderers
wanders114221333wan__ders
wanglers123310033wan_glers
wanions104011373wanion__s
wankers144514713wan__kers
wanner94019623wan__ner_
wanness102610683wan__ness
wantages12109023wantage_s
wanter94423053want__er_
wanton94413813wanton___
wantoning1337083wantoning
wantonly1443063wanton_ly
warmongers1643633warmongers
warners103315563wa__rners
warpowers1744553warpowers
warreners1236193warreners
wasters104026593wast__ers
watchers163511793wa_tchers
waterers112312783wa_terers
waters95030633wa_t__ers
whiteners1535243whiteners
wingovers1643553wingovers
winners104316913win__ners
winnowers1543953winnowers
winterers12209723winterers
winters103720483wint__ers
wonners104312813won__ners
wontons103310533wonton__s
xanthones1957023xanthone_s

Search took 10 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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411169.18616181.3
3Display Results1161160.0631841.3
 (SQL Overall)1786911169.42218965.3
 
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.