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

153 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
gasifies123869(None) 
basifies13310491basifies
gasified1336531gasified
gasifier1236271gasifier
gasifiers1344521gasifiers
basified1437822basified
basifier1337312basifier
basifiers1445202basifiers
casefies1339212casefies
falsifies1545982falsifies
gaseities1047082gaseities
gratifies1347992gratifies
nazifies2036062nazifies
ossifies1177562ossifies
pacifies15311222pacifies
ramifies13310502ramifies
rarifies11311932rarifies
ratifies11313512ratifies
salifies11314792salifies
salsifies1247252salsifies
aerifies111313393aerifies
alibies9313323_alibies
amities9317383_amities
asides75118873_asi_des
baffies153612943ba_ffies
bailies94120203ba_ilies
basifixed2242603basifixed
beatifies1459283beatifies
calcifies1638923calcifies
canities101519243canities
carnifies1439893carnifies
casefied1445943casefied
casimires1344693casimires
cavities131412613cavities
citifies13310683citifies
clarifies1448633clarifies
classifies1555003classifies
coalifies1439113coalifies
codifies1439643codifies
dailies84219263da_ilies
dairies84217733da_iries
daisies84217093da_isies
damnifies1545543damnifies
dandifies1476893dandifies
dassies84418663das_sies
deifies113317453_deifies
densifies1347993densifies
easies64126633eas__ies
edifies113012283_edifies
fairies103516043fa_iries
falsified1644983falsified
falsifier1544433falsifier
falsifiers1643233falsifiers
falsities1248133falsities
families1339443families
fancifies1767083fancifies
gabies93820733ga__bies
gadflies1334733gadflies
gaffes134811103ga__ffes
gaieties9310183gaieties
galaxies1637163galaxies
galilees936333galilees
gallflies1344223gallflies
gallies84122713ga_llies
gamines103618463gami_nes
gantries91413783gantries
garigues1034953garigues
gasalier936443gasalier
gasaliers1044513gasaliers
gaselier946963gaselier
gaseliers1044923gaseliers
gases65633993gas___es
gashes105725153gas__hes
gasiform1444303gasiform
gasify1336333gasif__y
gasifying1744523gasifying
gaskins123510773gas_kins
gasolier935833gasolier
gasoliers1044203gasoliers
gasolines1047483gasolines
gasses75724783gas__ses
gassier83812573gas_sier
gassiest93212523gas_siest
gastrins9310123gastrins
gaudies9311973ga_udies
gawkies15429123ga_wkies
gayeties1236883gayeties
glassies94012273glas_sies
glorifies1346363glorifies
gratified1446253gratified
gratifier1345823gratifier
gratifiers1443863gratifiers
gravities1338303gravities
griffes14367923g_riffes
gussies82813303gus_sies
ignifies1277563ignifies
justifies1945793justifies
laities7320343la_ities
lassies74420103las_sies
laxities1539093laxities
magnifies1547283magnifies
mashies12318253mas_hies
minifies13312893minifies
modifies1439163modifies
mystifies1745883mystifies
nasties73520493nas_ties
nazified2144993nazified
nidifies1238233nidifies
notifies11310423notifies
opacifies1645463opacifies
ossified1276433ossified
ossifier111196273ossifier
ossifiers1274883ossifiers
pacified1638363pacified
pacifier1557503pacifier
pacifiers1645463pacifiers
parities10522973parities
pasties94529813pas_ties
pastries101517423pastries
purifies13311923purifies
qualifies2147503qualifies
ramified1438043ramified
ramilies10311833ramilies
rarefies1138993rarefies
rarified1239053rarified
rarities8316333rarities
ratified12310503ratified
ratifier1139673ratifier
ratifiers1236453ratifiers
reifies104218283_reifies
russifies1245443russifies
salified12310363salified
sanities81219753sanities
sassies74719263sas_sies
satisfies1245323satisfies
scarifies1439603scarifies
tackifies1845783tackifies
taffies133012693ta_ffies
tassies74918933tas_sies
testifies12139263testifies
typifies1644963typifies
uglifies1246383uglifies
unifies102714713_unifies
vanities111414493vanities
varsities1239243varsities
vastities1248933vastities
verifies141313483verifies
versifies15159333versifies
vilifies1439593vilifies
vinifies1439873vinifies
vivifies1747023vivifies
waffies163611443wa_ffies
wastries111212883wastries

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621538.75016704.2
3Display Results1531530.0602550.0
 (SQL Overall)1786911538.96619929.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.