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 “amphiboles” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
amphiboles195276(None) 
amphibole1852861amphibole_
amphibolies2052441amphibolies
amphibolites2152442amphibolites
amphiboly2152282amphibol_y
amphibians1952933amphibians
amphibious1952843amphibious
amphibolite2052723amphibolite
amphibologies2352413amphibologies
amphibology2452473amphibology
amphigories1952543amphigories
amphimixes26122873amphimixes
amphioxus2352213amphi_oxus
amphiphiles2352053amphiphiles
amphipods1952673amphipo_ds
achiotes1339004a_chi_otes
airholes1138034airh__oles
ambles105121864am___b_les
ambones11312684am___bones
amidols10457564am__idol_s
amidones11348664am__idones
amitoses1039054am__itoses
amitroles1144724am_itroles
amniotes1036604am_ni_otes
amoles84122194am____oles
amphibia1744404amphib__ia
amphibian1853494amphib_ian
amphibrach2461594amphibrach
amphibrachs2561414amphibrachs
amphigory2051914amphigo_ry
amphimacer21102214amphimacer
amphimacers22141914amphimacers
amphimixis26112044amphimixis
amphioxi2252304amphi_o_xi
amphioxuses2551654amphioxuses
amphiphile2252174amphiphile_
amphiploid2073164amphiploid
amphiploids2172844amphiploids
amphipod1852574amphipo__d
amphoras1547084amph__oras
amplidynes1851704amplidynes
amplifies16106704ampli_fies
amplitudes1552914amplitudes
ampoules1275854amp__oules
ampules1189434amp___ules
anisoles81010124a__nisoles
antipoles11810474a_ntipoles
aphides134711204a_phi__des
archivolts1852174archivolts
armholes1347384armh__oles
assholes1146744assh__oles
audibles11215534a_udib_les
camisoles1345584cam__isoles
camphines1847564camphi__nes
camphires1845784camphi__res
camphols1746244camph__ol_s
caprioles1376754capri_oles
epibolies1345124_ep_ibolies
hyperboles2055944hyperboles
mandibles1445544mandib_les
manholes13311184manh__oles
phimoses1537204__phimoses
pinoles93418704__p_inoles
rampoles1238894ramp___oles
samphires1645514samphi__res
tapholes1339624taph__oles

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 Filter1786911614500.453394461.4
2DLD Change Limit161450669.40617164.6
3Display Results66660.0302200.0
 (SQL Overall)178691669.88918069.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.