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

209 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
abatises1031101(None) 
abattises1155081abattises
abacuses1235762abacuses
abases85720772aba__ses
abates85825032abat__es
abatis84317932abati__s
ablatives1445502ablatives
abscises1246232abscises
agatizes1838862agatizes
anatases839792anatases
apatites10311282apatites
azotises1737602azotises
baptises1238922baptises
batistes1039712_batistes
betises94816122_betises
abalones1038753abalones
abase76023483aba__se_
abased96514993aba__sed
abaser86414343aba__ser
abasers95311973aba__sers
abashes12510373aba_shes
abasias9711013abasi_as
abate76627843abat__e_
abated95918453abat__ed
abater85518123abat__er
abaters95115203abat_ers
abating10413973abati_ng
abators94413083abat_ors
abattis9297823abat_tis
abaxile1644083abaxile_
abbacies1445483abbaci_es
abbesses1235333abbesses
abides94719893ab__ides
abioses9311493ab_ioses
ablates92416903ablat__es
ablations11311503ablations
ablative1348243ablative_
ableisms1245413ableisms
ableists1036543ableists
abolishes1446053abolishes
abortuses1144993abortuses
abrasives1444063abrasives
abscise1145953abscise_
abscised1364133abscised
abuses85119103ab__uses
abysses1234863ab_ysses
acariases1146613acariases
acarines10314343acarines
actives12311523a_ctives
adonises92611433adonises
advises11138973a_dvises
aegises8311373a_egises
agaroses938823agaroses
agates76121343agat__es
agatize1739833agatize_
agatized1947073agatized
agonises92613163agonises
airtimes1037503airtimes
alanines8314803alanines
alates64833963alat__es
alations82518893alations
alkalises13167483alkalises
amasses93912853ama_sses
amative12311733amative_
ambaries123312383ambari_es
amities9317383amiti_es
amitoses1039053amitoses
amortises1178823amortises
anabases1038083anabases
anabioses1145403anabioses
anaclises1147863anaclises
analyses11149963analyses
anatase738943anatase_
anatomises1297353anatomises
anises64826693__anises
antisex1439693a_ntisex
apathies1339003apathies
apatite9312963apatite_
apprises12310963apprises
arabizes1969103arabizes
arbalists1148483arbalists
arbutuses1143723arbutuses
arises65233803__arises
arrises71617583a_rrises
artistes83213343a_rtistes
artists74215593a_rtists
aspises9611643a_spises
astatines9310343astatines
atavisms1346993atavisms
atavists1137583atavists
ataxies142410013ataxi_es
atomises103514403atomises
attires72312953a_ttires
aunties73920073aunti_es
autisms94311553a_utisms
autists73814853a_utists
avarices1337183avarices
axises134413993__axises
azotise1637073azotise_
azotised1844443azotised
azotizes1636853azotizes
baalisms1238033baalisms
baases85218013_ba_ases
babies106123653_babi_es
baizes174315053_ba_izes
balases93815433_balases
banishes131812463_banishes
banties94324763banti_es
baptise1139553baptise_
baptised1335263baptised
baptisms1446033baptisms
baptists1236723baptists
baptizes2136843baptizes
barites94322333_barites
bases75644353_ba__ses
basses85428303_ba_sses
bastiles10313353bastiles
batches144019613_batches
bates75846343_bat__es
batfishes1746583_batfishes
bathes116524833_bat_hes
bathoses13310463_bathoses
batiked1435963_batiked
batiks1239373_bati_ks
batiste939743_batiste
battles94517683_battles
battues94610193_battues
bawties124214313bawti_es
betides104915263_betides
betimes115114413_betimes
betise85616273_betise_
bises75435623_b__ises
braises93818873_braises
brises84927613_b_rises
bruises93212913_bruises
bubalises1346323bubalises
cabalisms1548433cabalisms
cabalists1339143cabalists
camises114218463_camises
canalises11515493canalises
chaises124317493cha_ises
chamises153513313chamises
chastises1437703chastises
cutises94414913_cutises
daises74318983_da_ises
datives11310073_datives
dramatises1356743dramatises
ebonises1039223ebonises
elatives1139783elatives
etatisms1038293etatisms
faradises13248983faradises
flatuses1137173flatuses
fraises104215693fra_ises
glacises1138503glacises
hiatuses1135773hiatuses
ibises83610543ib__ises
iritises839973iritises
isatines8310663isatines
kabalisms1745953kabalisms
kabalists1546293kabalists
kyanises15206393kyanises
lapises93513463_lapises
latices9313763_latices
laxatives1943353laxatives
liaises7311053lia_ises
malaises10312333mala_ises
mantises10317923mantises
mavises122812993_mavises
meatuses1038203meatuses
mitises9315543_mitises
mortises10713613mortises
nasalises948113nasalises
natives10310823_natives
obelises1039103obelises
otitises839163otitises
oxalises1538503oxalises
paganises1239723paganises
palatines11313033palatines
paradises122513203paradises
parises94827183_parises
pastises103616053pastises
patines95225763_patines
patsies93919483_patsies
pavises125315493_pavises
platies93722543plati_es
poetises10313953poetises
practises1349623practises
praises94121103pra_ises
praxises1739063praxises
raises64826543_ra_ises
ratines75328583_ratines
ratites74920683_ratites
realises82420183realises
sanitises91111743sanitises
satires72617573_satires
statices102712343statices
statisms1039543statisms
statists8310163statists
statives112710793statives
statuses8409543statuses
tabbises12236523tab_bises
tamises92715973_tamises
tapises92914013_tapises
teatimes1039443teatimes
treatises9310373treatises
urbanises11106643urbanises
valises103516263_valises
whatsises1543203whatsises
zaratites1847003zaratites

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.1561145455.1
2DLD Change Limit1461622098.56317069.0
3Display Results2092090.0932247.3
 (SQL Overall)1786912098.81220278.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.