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

102 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
aphorise133998(None) 
aphorised1546361aphorised
aphorises14310001aphorises
aphorism1548641aphorism
aphorist13412501aphorist
aphorize2249041aphorize
ahorse9311512a_hor_se
aphorisms1647192aphorisms
aphorists1448252aphorists
aphorized2446442aphorized
aphorizer2345402aphorizer
aphorizes2348002aphorizes
apprise11310192ap_prise
authorise1248022authorise
vaporise13209632vap_orise
abhors11410623abhor_s_
actorish1349433actorish
agonise83112693a_gonise
algorism1147353algorism
alphorns1345213alphorns_
alphosis1347273alphosis_
alphosises1544023alphosises
amorist9317643a_morist
amortise10428513a_mortise
amphorae1546263amphor_ae
amphoras1547073amphoras_
anchorite1448823anchorite
aorist64827873a__orist
aperies9423203ap_eries
aphanite1348773aphanite
aphereses1466423aphereses
aphesis12610513aphesis_
aphis105917133aph__is_
apholate13410473apholate
aphonia122711883aphoni_a
aphonias132611143aphonias
aphonic142713393aphoni_c
aphonics15259523aphonics
aphorising1645733aphorising
aphoristic1746343aphoristic
aphorizers2443583aphorizers
aphotic142913113aphoti_c
aphrodite1545483aphrodite
apiaries10312713apiaries
apiarist10412053apiarist
apocrine1246933apocrine
apologise1248303apologise
aporia8315863ap_ori_a
aporias9315133ap_orias
appose10411993appo__se
apposite12410013apposite
appraise1247703appraise
apprised1337713ap_prised
appriser1246783ap_priser
apprises12310963ap_prises
apprize2038183ap_prize
apyrase1236363ap_yrase
arborist10411613arborist
arborize1988963arborize
arise56436433a___rise
armories10313653armories
ashore9414613ashor__e
atomise93013823a_tomise
authorised1444513authorised
authorises1347573authorises
authorize2146903authorize
azotise1637073a_zotise
chorine123218363_chorine
diaphorase1673283diaphorase
ephorate1359503ephorate
ephori1139603ephori__
ephors11311403ephor_s_
hoise85224773__ho_ise
horse86132653__hor_se
memorise121411433memorise
motorise10311523motorise
pharisee1347593_pharisee
phocine1438833_phocine
phonies123717513_phonies
phorate12413363_phorate
phoresy1534653_phoresy
phrase11109903_ph_rase
poise75127893_p_o_ise
pooris83916843_pooris_
poorish123712303_poorish
porism104518063_p_orism
porose84818743_p_orose
prise74632613_p__rise
promise113415843_promise
sawhorse1443523sawhor_se
taphouse1346333tapho_use
theorise1137873theorise
thorite10313443_thorite
unhorse1038583unhor_se
uprise82313693up__rise
valorise112110303valorise
vaporised15216953vap_orised
vaporises14209453vap_orises
vaporish16246733vap_orish
vaporize22239173vap_orize
warhorse1445343warhor_se
whorish1636603_whorish

Search took 9 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 Filter1786911461620.186960704.3
2DLD Change Limit1461621028.17317883.5
3Display Results1021020.0462217.4
 (SQL Overall)1786911028.40521260.1
 
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.