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

43 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
genipap124312(None) 
genipaps1342161genipaps
genial74917612geni_al
genip84415202geni__p
genips9469942genip_s
genital849792genital
denial74720513deni_al
entrap8710563_entrap
enwrap1185213_enwrap
gelcap1136213ge_lcap
geminal10109893geminal
genera71211713genera_
general81010933general
geneva1085853geneva_
genevas1185253genevas
genic85119393geni__c
genie66124923geni__e
genies75324943geni_es
genii64514173geni__i
genitals937243genitals
genitor837273genitor
genius74512923geni_us
genoa64315823gen_oa_
genoas74013623gen_oas
gentian8310103gentian
genua64614153gen_ua_
geoidal936703geoidal
gonia64117533goni_a_
helipad1344723helipad
medigap1374623medigap
menial84223033meni_al
nipa69421633__nipa_
nipas77116673__nipas
oedipal1045173oedipal
pedipalp1242513pedipalp
penial84120893peni_al
tenia55324483teni_a_
teniae64517353teni_ae
tenias64720073teni_as
venial94218283veni_al
xenia124814773xeni_a_
xenial133414903xeni_al
xenias133712973xeni_as

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.1561145455.1
2DLD Change Limit134027436.68620045.9
3Display Results43430.0162687.5
 (SQL Overall)178691436.85826055.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.