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

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

96 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
groin6552108(None) 
grain65126251grain
grin55733721gr_in
groan65618421groan
groins73917201groins
grown95317351grown
aloin55227422aloin
aroid65428342aroid
aroint6328152aroint
brain76229382brain
brin67038192br_in
broil74918222broil
bromin102615692bromin
brown105619532brown
bruin75818332bruin
coin66645352_coin
croon75522782croon
crown105620082crown
drain65222892drain
droid74218542droid
droit65127122droit
drown95515822drown
eloin55923202eloin
foin77231562_foin
frown115415972frown
gain56042162g_ain
gamin84423002gamin
geoid74215762geoid
gin46055752g__in
giron66118992giro_n
globin9309722globin
going75218492g_oing
goon57236172g_oon
goring84119572goring
gown85724072g_own
gradin83517482gradin
grail64622872grail
grains74223092grains
grainy103914212grainy
gran56335012gr_an
gratin74520582gratin
green65522142green
grid65829612gr_id
grig65424772gr_ig
grim76929422gr_im
grind75917562gr_ind
grins65427222gr_ins
griot65328412griot
grip76127022gr_ip
grit55247242gr_it
groans74815062groans
groat65531972groat
grody103412062grody
grog65923342gro_g
grogs76319412grogs
groined92710812groined
grok95819682gro_k
groks105716122groks
groom85317982groom
grope84821612grope
groping113313102groping
gross65421692gross
grosz154814092grosz
grot55942052gro_t
grots65025852grots
ground82310272ground
group85413922group
grout65330422grout
grove95219332grove
grow86127302gro_w
growing123512472growing
growl96115822growl
grows95523922grows
groyne1037212groyne
gyron95314622gyro_n
heroin94420592heroin
iron46728462iro_n
join116724832_join
kroon94514482kroon
ligroin848042ligroin
loin46838722_loin
orcin72716572orcin
orpin73415532orpin
prion75119992prion
quoin144012322quoin
rain46251732_rain
rein46040892_rein
rin36663182_r_in
roan47234202_roan
robin74820282_robin
roil46235292_roil
rosin55325312_rosin
ruin47430512_ruin
train56529112train
trois57226092trois
tropin83316752tropin

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800961.45337026.8
3Display Results96960.0332909.1
 (SQL Overall)178691961.79999328.0
 
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.