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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
aphorises1431000(None) 
aphorise1339981aphorise_
aphorised1546361aphorised
aphorisms1647191aphorisms
aphorists1448251aphorists
aphorizes2348001aphorizes
alphosises1544022alphosises
aphereses1466422aphereses
aphorism1548642aphoris_m
aphorist13412502aphoris_t
aphorize2249042aphorize_
aphorized2446442aphorized
aphorizer2345402aphorizer
aphorizers2443582aphorizers
apprises12310962ap_prises
authorises1347572authorises
vaporises14209452vap_orises
adonises92611433a_donises
aepyornises1651143aepyornises
agonises92613163a_gonises
ahorse9311513a_hor_se_
algorisms1246173algorisms
amorists10411323a_morists
amortises1178823a_mortises
anchorites1547753anchorites
aorists74215823a__orists
aperies9423203ap_eri_es
aphaereses1553163aphaereses
aphanites1448263aphanites
apheresis1475333apheresis
apheses12610703aph__eses
aphides134711203aph__ides
apholates1449683apholates
aphonias132611143aphoni_as
aphonics15259523aphoni_cs
aphorising1645733aphorising
aphoristic1746343aphoristic
aphrodites1644993aphrodites
apiaries10312713apiari_es
apiarists1147873apiarists
apoapses1244713ap_oapses
apodoses1136653ap_odoses
apologises1347303apologises
apomixes1934853ap_omixes
aporias9315133ap_ori_as
apposes11511473appo__ses
appraises1347423appraises
apprise11310193ap_prise_
apprised1337713ap_prised
appriser1246783ap_priser
apprisers1345053ap_prisers
apprizes2137793ap_prizes
apyrases1337243ap_yrases
arborists1147443arborists
arborizes2088813arborizes
arises65233803a___rises
armories10313653armori_es
arrises71617583a__rrises
atomises103514403a_tomises
authorise1248023authorise_
authorised1444513authorised
authorizes2247003authorizes
azotises1737603a_zotises
chorines132917253_chorines
choruses1339983_choruses
diaphorases1773353diaphorases
diaphoreses1762563diaphoreses
ephorates1459153ephorates
gaposises1245523gap_osises
hoises94823673__ho_ises
horses94729343__hor_ses
lorises73918593__lorises
memorises131211573memorises
motorises11311663motorises
parises94827183_p_arises
pharisee1347593_pharisee
pharisees1444633_pharisees
pharoses13310313_pharoses
phereses1348093_phereses
phonies123717513_phoni_es
phorates13413043_phorates
phoresies1447993_phoresies
phrases12711463_ph_rases
phthises1645713_phthises
poises84226543_p_o_ises
porisms113713453_p_orisms
prises84133173_p__rises
promises122916763_promises
psoriases1144863_psoriases
sawhorses1543753sawhor_ses
taphouses1446553tapho_uses
theorises1247813theorises
thorites11312393_thorites
unhorses1138453unhor_ses
uprises92012733up__rises
valorises122210173valorises
vaporise13209633vap_orise_
vaporised15216953vap_orised
vaporizes23228513vap_orizes
warhorses1545573warhor_ses
whosises1435333_whosises

Search took 7 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 Filter1786911486410.190940478.9
2DLD Change Limit1486411016.37323323.6
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.60927037.5
 
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.