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

79 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
allobar94666(None) 
allobars1046581allobars
allosaur8133822allosaur
allover1038582allover
alloxan1445772alloxan
isallobar1151542isallobar
kilobar1344612kilobar
lobar7313012__lobar
acrobat11411813acrobat
aerobat9514473aerobat
afloat9315153aflo_at
alar46340073a_l__ar
alba68328333a_l_ba_
albas75925393a_l_bas
alcazar1843453alcazar
alegar739283a_legar
algebra1043043algebra
algor6513053algo__r
allay85620393all__ay
allayer10148213allayer
alleger8319633alleger
allheal1044553allheal
allocate10411023allocate
allocator1145783allocator
allod64418383allo__d
allodia8128793allodia
allodial9117393allodial
allods73615083allo_ds
allogamy1443993allogamy
allonge837023allonge
allonym1244733allonym
allopath1345803allopath
allopatry1453613allopatry
allosaurs9134163allosaurs
allot54933873allo__t
allots64019173allo_ts
allotter866473allotter
allovers1137673allovers
allow85420663allo__w
allowed111610083allowed
allows94517683allo_ws
alloxans1545243alloxans
alloy85519973allo__y
alloyed11158033alloyed
alloys94014563allo_ys
allurer7348433allurer
almemar1144303almemar
almoner949383almoner
aloha8513613a_loha_
alohas9411703a_lohas
altar55520643a_l_tar
alular6311353a_lular
alveolar1143293alveolar
areolar779223areolar
arroba898663arroba_
arrobas969213arrobas
balloter1078893balloter
bulbar1039583bul_bar
callboard1445663callboard
callower13159073callower
fallboard1545053fallboard
galloper11137183galloper
global937663_global
halloa94918123hallo_a_
halloas104318463hallo_as
hallower14139813hallower
isallobars1251543isallobars
isobar836143_isobar
kilobars1444933kilobars
lumbar103610593_lumbar
malleolar1143263malleolar
millibar1275353millibar
pallor8313673pallo__r
sallower11139503sallower
tollbar945453tollbar
toolbar944773toolbar
wallboard1545023wallboard
walloper13147113walloper
wallower14158933wallower

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 Filter1786911340270.393454684.5
2DLD Change Limit134027799.34314345.2
3Display Results79790.0302633.3
 (SQL Overall)178691799.76618297.3
 
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.