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

214 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
ratfish133877(None) 
batfish1558681batfish
catfish1559021catfish
raffish1658841raffish
rattish10510821rattish
baitfish1645482baitfish
brattish1346972brattish
cattish12410722cattish
crawfish1944232crawfish
crayfish1944252crayfish
draffish1844552draffish
fattish1359262fattish
flatfish1744932flatfish
garfish14179202garfish
goatfish1544292goatfish
grayfish1844482grayfish
hagfish17227612hagfish
latish92416172lat_ish
oafish121311722oa_fish
oarfish13158612oarfish
outfish132210572outfish
panfish15229972panfish
radish103516912ra_dish
rakish134313962ra_kish
rammish1437562rammish
rankish14510382rankish
raspish1298102raspish
ratfink1434942ratfink
ratfishes1546102ratfishes
ravish123414032ra_vish
rawish123012912ra_wish
redfish1437792redfish
ruttish1048302ruttish
sawfish1637682sawfish
waifish1637702waifish
aguish1059283_aguish
apish105116633_a_pish
artist64125543art_ist
aspish114810333_aspish
babyish1736513babyish
baldish1339503baldish
banish111416043ba_nish
batfishes1746583batfishes
boarfish1635753boarfish
boxfish2285543boxfish
brackish1987613brackish
brainish1338813brainish
brandish1469023brandish
brassish1346433brassish
brutish1237703brut_ish
caddish143810123caddish
carlish12312763carlish
catfight1744273catfight
catfishes1746303catfishes
cavefish1974853cavefish
coalfish1635493coalfish
codfish1637163codfish
cowfish1836433cowfish
crampfish2142593crampfish
crankish1736513crankish
dampish1567663dampish
danish101513793da_nish
darkish1537943darkish
deafish1438533deafish
dealfish1545503dealfish
dogfish15226763dogfish
drumfish1743503drumfish
dwarfish1843783dwarfish
elfish1267963_elfish
faddish15359003faddish
fairish1338993fairish
fallfish1744463fallfish
famish14311843fa_mish
fetish12310373fet_ish
finfish16268193finfish
fish106926273___fish
flattish1455263flattish
foxfish2354483foxfish
frogfish1843943frogfish
frostfish1842623frostfish
garish104516923ga_rish
garnish111610843garnish
gawkish1835833gawkish
giraffish1941973giraffish
goatish1139563goat_ish
gratis74819243grat_is_
grayish1437813gra_yish
gruffish1843943gruffish
haggish15207473haggish
haimish1537753haimish
hashish1238353hashish
hawkish2036553hawkish
headfish1845443headfish
hogfish17257023hogfish
hottish13117893hottish
huffish1935713huffish
jackfish2744123jackfish
jadish17319903ja_dish
jewfish2343543jewfish
kaddish16317973kaddish
laddish12299723laddish
ladyfish1843803ladyfish
ladyish14287823ladyish
largish1138603largish
larkish1439083larkish
lathis95516173lathis_
lavish124112983la_vish
lazyish22265853lazyish
leftish13197253leftish
lutfisk1443583lutfisk
maddish14289483maddish
maidish13239553maidish
mannish121710693mannish
marish114319053ma_rish
mawkish1935823mawkish
mudfish1646263mudfish
offish15137273_offish
orangish1246543orangish
outwish13289853outwish
palish114718273pa_lish
parish115022353pa_rish
patois84319363patois_
pettish1238283pettish
pigfish16217173pigfish
pinfish15319303pinfish
platyfish2042683platyfish
prankish1737023prankish
pupfish1735533pupfish
rabbis102613153rabbis_
rachis114017653rachis_
racism103214193ra_cism
racist82822793ra_cist
raffia12287703raffi_a
raffias13237713raffias
raffishly2143303raffishly
raffs115017523ra_ffs_
rafting113815753rafting
rafts87820633ra_fts_
ragis66325603ra_gis_
rais45252623ra__is_
raise54828053ra__ise
rakis95323443ra_kis_
ranis55235833ra_nis_
raphis114014323raphis_
rapist82520673ra_pist
rash76039933ra___sh
ratafia1045773ratafi_a
ratafias1145323ratafias
ratals64219583ratals_
ratans63819373ratans_
ratch104221363rat__ch
ratels64518213ratels_
raters63936573raters_
rates55352013rat_es_
ratfinks1542853ratfinks
rath76037663rat___h
ratified12310503ratified
ratifier1139673ratifier
ratifies11313513ratifies
ratify122610043rat_ify
ratine65131823rat_ine
rating74938703rat_ing
ratio55227583rat_i_o
ration64226013rat_ion
ratios64922673rat_ios
ratite65022423rat_ite
ratlike113912353ratlike
ratlin64116523ratli_n
ratline74517803ratline
ratlins73615583ratlins
ratos55528763rat_os_
rats46260373rat__s_
rattier74015593rattier
rattiest83516113rattiest
ratting83822363ratting
reddish1238033reddish
relish93916953r_elish
retwist1039483retwist
rockfish2043903rockfish
roguish1156833roguish
rompish1436693rompish
rosefish1445263rosefish
rotis56327053rot_is_
rubbish1436303rubbish
runtish1048693runtish
sailfish1446053sailfish
saltish10312163saltish
sandfish1556683sandfish
satis55633673sat_is_
selfish1388513selfish
serfish1348973serfish
sheatfish1843243sheatfish
softish13127813softish
sottish10129433sottish
starfish1438083starfish
sunfish1338883sunfish
tallish103313583tallish
tannish101610573tannish
tarnish101611873tarnish
tartish101512633tartish
toadfish1544903toadfish
trampish1535643trampish
vampish1766283vampish
vanish121513203va_nish
varnish13169533varnish
waggish15207073waggish
wampish1777293wampish
warmish1538373warmish
waspish1586923waspish
waterish14310533waterish
weakfish2143523weakfish
wettish1335963wettish
wolfish1636933wolfish
zanyish2235903zanyish

Search took 8 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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272147.00319138.5
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.23224708.4
 
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.