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

111 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
tolar5552411(None) 
bolar75123471bolar
molar75223091molar
polar75623451polar
solar55927341solar
talar56225381talar
tola45236331tola_
tolan55124011tolan
tolars64817921tolars
tolas54532771tolas
volar86917411volar
alar46340072_alar
boar66134292bo_ar
bola66035562bola_
bolas74733762bolas
boyar106013762boyar
cola66541392cola_
colas75436772colas
collar83816172collar
color76123742color
dollar74110982dollar
dolor67617962dolor
filar84819292filar
foliar93210972foliar
gular6314832gular
hilar85418142hilar
hoar76729162ho_ar
holard10410572holard
jowar155211432jowar
kola85124962kola_
kolas94822232kolas
lar37967532__lar
lobar7313012lobar
malar76424442malar
mola66035632mola_
molal75120342molal
molars85517322molars
molas75132092molas
mylar105311532mylar
oar37057952_o_ar
osar46820952_osar
ottar54313992ottar
pilar75221502pilar
polars84419352polars
poler74431792poler
poplar103611112poplar
roar46328572ro_ar
soar46838672so_ar
sofar86115492sofar
sola45541862sola_
solan55328152solan
sonar56523422sonar
sowar85821342sowar
stelar64013862stelar
stylar9358112stylar
tala45938052tala_
talars66021682talars
talas55935892talas
taler56034862taler
tar37570692t__ar
tatar56122062tatar
tear45242882t_ear
tela45532972tela_
telae54323292telae
tilak91011552tilak
tiler56131022tiler
toad55830182to_ad
today96416952today
toea46732332toea_
toeas55726422toeas
toga57027412toga_
togae67020112togae
togas67823002togas
toiler63918282toiler
tokay125513052tokay
toker95924912toker
tolane64316582tolane
tolans64319272tolans
told56132202tol_d
tole46052902tol_e
toled65934922toled
toles55147132toles
toll45535262tol_l
tollbar945442tollbar
toller63819442toller
tolls54728432tolls
tolu45529152tol_u
tolus55024482tolus
tolyl84710092tolyl
toman75724052toman
tonal53724302tonal
toner55336242toner
toolbar944762toolbar
tooler63818612tooler
topaz16315322topaz
toper75231022toper
tor39261682to__r
tora47545992tora_
torah87125272torah
toras55540372toras
torr45630902to_rr
total55321822total
toter55932132toter
tour45530372to_ur
toward10311062toward
tower85729202tower
toyer84521552toyer
trocar848762trocar
tsar47819802t_sar
tzar136315372t_zar
velar85817632velar

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001111.86028924.7
3Display Results1111110.0303700.0
 (SQL Overall)1786911111.98390111.4
 
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.