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

94 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
aerobat951447(None) 
acrobat11411811acrobat
aerobats1049841aerobats
aerosat7417181aerosat
acrobats1258342acrobats
aerobatic1399002aerobatic
aerobe8412402aerob_e
aerobes9311492aerobes
aerobia939462aerobia
aerobic11310212aerobic
aeronaut869652aeronaut
aerosats8411012aerosats
aerostat8410682aerostat
airboat9512132airboat
arroba898662arroba_
arrobas969212arrobas
abroad9310943abro_ad
abrogate11129603abrogate
acerbate1247533acer_bate
acerola947823acerola_
acerolas1048053acerolas
achromat15410103achromat
acrobatic1587733acrobatic
adroit7518793adro_it
aerate64830553aer__ate
aerial64625713aer_ial
aeriest73924053aeriest
aero45435343aero___
aerobatics1465803aerobatics
aerobics1246833aerobics
aerobium1246303aerobium
aerobrake1543583aerobrake
aeroduct1155633aeroduct
aerogel836523aerogel
aerogram1149523aerogram
aerolite8315053aerolite
aerolith1149833aerolith
aeronauts975163aeronauts
aerosol747683aerosol
aerostats946713aerostats
afloat9315153aflo_at
airbag956963air_bag
airboats1047283airboats
allobar946663allobar
approbate1546563approbate
araroba945763araroba_
ararobas1046183ararobas
areola6813673areola_
areolae7811733areolae
areolar779223areolar
areolas71013863areolas
areolate81014453areolate
arhat8327093a_r_hat
aroint6328153a_roint
aroma71220143a_roma_
aromas81018613a_romas
aroynt9312893a_roynt
arriba867683arriba_
arrogant949153arrogant
arrogate91210323arrogate
aurora6411763aurora_
aurorae739663aurorae
auroral7310473auroral
auroras7311703auroras
automat9414873automat
bareboat1249943bareboat
berobed1238233berobed
deorbit1048173deorbit
derat65044083der__at
derogate10311353derogate
ferbam1339003fer_bam
groat65531973_gro_at
herbal112513493her_bal
hereat93527413her_eat
jerboa1535633jerboa_
jerboas1636163jerboas
jeroboam1943603jeroboam
peroral9314793peroral
perorate10417923perorate
probate11414483_probate
probit103218353_probit
rabat72832223__rabat
recoat84024273reco_at
reprobate1347683reprobate
robot7325973__robot
serosa6313023serosa_
serosae7310243serosae
serosal7311153serosal
serosas7312663serosas
serovar1046143serovar
throat94819753thro_at
verbal112513663ver_bal
yerba101010763yer_ba_
yerbas11119293yer_bas

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.1561145455.1
2DLD Change Limit134027947.33018284.7
3Display Results94940.0303133.3
 (SQL Overall)178691947.51623774.7
 
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.