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

93 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
tarweed1137341tarweed
tarweeds1244272tarweeds
areae55229743_ar_eae
arene55329413_ar_ene
arete56031353_ar_ete
atween9166613_atween
awee76336643_a_w_ee
barege94713543bar_ege
bargee94624443bar_gee
bargees105415873bargees
barkeep1536363barkeep
barware12610703barware
bawbee132714233ba_wbee
burweed1347823burweed
careen84119493car_een
career85822243car_eer
drawee104413823draw_ee
drawees11378363drawees
hareem114312063har_eem
laree56036293lar__ee
larees65323113lar_ees
marquee18218583marquee
mayweed1634163mayweed
pardee93922023par_dee
pareve114613013par_eve
parolee94119643parolee
pawnee113115403pa_wnee
ragweed1235073ragweed
saree55044663sar__ee
sarees65329943sar_ees
tagmeme1243353tagmeme
tardier859719993tardier
tardies84225863tardies
tardive1136893tardive
tare45957623tar___e
tared69340053tar__ed
tares57456563tar__es
targe65227093tar__ge
targes74524593tar_ges
target75028903tar_get
targeted1037483targeted
targets84314223targets
tarre55825633tar__re
tarred74720283tar_red
tarres64723043tar_res
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
tarsier74119253tarsier
tartare73012683tartare
tarted74923373tar_ted
tarter64023563tar_ter
tartest72517533tartest
tartier74123263tartier
tartlet72218483tartlet
tartufe1064673tartufe
tawed95926193ta_w_ed
tawer85223443ta_w_er
tawers94118603ta_wers
tawie84819813ta_w_ie
tawney12338233ta_wney
tawpie11339143ta_wpie
tawse85616503ta_w_se
tawsed10499743ta_wsed
tawses94913193ta_wses
taxeme1536253ta_xeme
taxwise1734253taxwise
terete6319333ter_ete
terpene92310863terpene
terreen7257573terreen
terrene72411033terrene
three87526913thr__ee
threep115910113thr_eep
threes97117323thr_ees
towhee122613883t_owhee
townee92815213t_ownee
trainee72817793trainee
trapeze1836253trapeze
trawled113411523trawled
trawler104011903trawler
trawley13317303trawley
tree47745813t_r__ee
treed65626733t_r_eed
treen55622753t_r_een
trees55835763t_r_ees
triene64316383t_riene
tureen63312723tur_een
twee76827083t__w_ee
tweed94915093t__weed
tween84413743t__ween
tweet84823983t__weet
tweeze18265473t__weeze
waxweed2132923waxweed

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 Filter1786911340270.406440125.6
2DLD Change Limit134027936.59320328.7
3Display Results93930.0303100.0
 (SQL Overall)178691937.02925422.0
 
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.