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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
frogeye144381(None) 
frogeyed1642781frogeyed
frogeyes1543741frogeyes
fogey125617872f_ogey_
fogeys13509262f_ogeys
froggy1434492froggy_
apogee9312563apoge_e
bigeye1236643_bigeye
bogey115220233_bogey_
bogeyed1435673_bogeyed
bogeys124510913_bogeys
boogey124711523boogey_
boogeyed1543723boogeyed
boogeys13476873boogeys
brogue94211033brog_ue
bugeye1236533_bugeye
dogey105719513_dogey_
dogeys115510663_dogeys
dragee84415603drage_e
drogue8938333drog_ue
fisheye1644773fisheye
flooey123910173flooey_
foggy136714543f_oggy_
fogie96719003f_og_ie
fogy115923183f_og_y_
foley115222303f_oley_
foleys123810463f_oleys
forbye14427883f_orbye
forebye1536353forebye
forgave1435853forgave
forge95126943forg__e
forged115519323forge_d
forger104820773forge_r
forgers115218183forgers
forgery14419303forgery
forges105024263forge_s
forget106326393forge_t
forgets113813793forgets
forgive1436193forgive
forgone1139343forgone
formee113919943forme_e
foveae1237563f_oveae
fragile1147843fragile
free75940183fr__e_e
freeze18349513fr_eeze
frere85617723fr__ere
frieze18378143fr_ieze
frigate11311063frigate
friges104116483frige_s
frisee94217993frise_e
froe75329993fro___e
froes86126693fro_e_s
frog85624363frog___
frogged13408493frogged
froggier1354643froggier
froglet11310063froglet
froglets1235263froglets
froglike1634363froglike
frogman1335873frogman
frogmen1335893frogmen
frogs96220773frog__s
fromage1336753fromage
frore86218803fro__re
frosty124710633frosty_
frothy15578373frothy_
frounce1236153frounce
frouzy21395283frouzy_
frowsy15498273frowsy_
frowzy24485793frowzy_
froze174515653fro__ze
frozen18408443froze_n
groggy1234803groggy_
mooneye12116933mooneye
neogene847553neogene
ogee57629883__oge_e
orogeny11107023orogeny
oxeye1536913__oxeye
pogey116017893_pogey_
pogeys124110353_pogeys
progeny1389463progeny
propene112716043propene
protege1059153protege
ragee65432663_rage_e
redeye103811793_redeye
roger64521413_roge_r
rogered939553_rogered
rogers74517913_rogers
rogue66417533_rog_ue
ropey106021873_ropey_
stogey105811543stogey_
stogeys11486123stogeys
urodele845963urodele
yogee9518063_yoge_e

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 Filter1786911340270.406440125.6
2DLD Change Limit134027936.14021828.5
3Display Results93930.0332818.2
 (SQL Overall)178691936.57927160.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.