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

67 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
abomasi1111549(None) 
abomas101113581abomas_
abomasa11114611abomasa
aboma91114602aboma__
abomasal12112842abomasal
abomasum1441812abomasum
abomasus1242852abomasus
aromas81018612aromas_
abacas104414723abacas_
abaci94718843ab__aci
abakas123911743abakas_
abamps1236253abamps_
abas68642083ab__as_
abase76023483ab__ase
abash106016513ab__ash
abasia8712953ab__asia
abayas114011703abayas_
abbas95918643ab_bas_
aboard9312613abo_ard
abodes94417513abodes_
abohms1335003abohms_
abolish12311503abolish
aboral8314373abora_l
aborts84916183aborts_
abos67734413abo__s_
aboves114512843aboves_
abreast9311273abreast
admass957143a_dmass
agamas97413443agamas_
agmas85919873a_gmas_
agoras7613343agoras_
almas76629773a_lmas_
alohas9411703alohas_
amas67746293a__mas_
amass77119683a__mass
animas84418723animas_
anoas57226493ano_as_
anomaly1238843anomaly
aroma71220143aroma__
aromatic12315613aromatic
atmas75721013a_tmas_
atomise93013823atomise
atomism112610963atomism
atomist92915763atomist
atoms76817563atom_s_
basmati1148233basmati
bemas96424283_bemas_
bimas95521743_bimas_
biomass1155993biomass
boas66150833_bo_as_
boast75935703_bo_ast
bolas74733763_bolas_
bombast1348223_bombast
bombs115818823_bombs_
bonaci10310963_bonaci
bonsai838463_bonsai
boras75938303_boras_
botas75328783_botas_
cabombas1643813cabombas_
caeomas1138393caeomas_
comas95833003_comas_
myomas1338293myomas_
nomas74726413_nomas_
omasa749483__omasa
romaji1534883_romaji
somas76030373_somas_
stomas84816323stomas_

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.1731032896.0
2DLD Change Limit134027678.89015076.2
3Display Results67670.0164187.5
 (SQL Overall)178691679.07919681.8
 
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.